Question
Additional information on the financial results of the company Caribe Supplies Inc. This information plus the projections are based on the basis for planning and
Additional information on the financial results of the company Caribe Supplies Inc. This information plus the projections are based on the basis for planning and preparing budgets for next year.
SALES FOR MONTHS DURING THE PAST YEAR 2015
JANUARY $ 320,000 FEBRUARY $ 400,000 MARCH $ 525,000 APRIL $ 470,000 MAY $ 680,000 JUNE $ 725,000 JULY $ 490,000 AUGUST $ 560,000 SEPTEMBER $ 680,000 OCTOBER $ 660,000 NOVEMBER $ 790,000 DECEMBER $ 890,000
According to the plans of the company it is estimated that a 15% increase in sales reported during the months of last year appropriate child.
THE SALES CHARGES ARE BEING PROJECTED IN THE FOLLOWING WAY:
60% of the sales of each month are projected to be charged during the same month. Due to a new billing policy, a half (11/2)% discount is offered if customers pay within ten days from the billing date. It is expected that 3/5 of the customers will benefit from this collection term.
20% of the sales of each month are projected to be charged the month following the month of the sale.
15% of the sales of each month was created in charging the two months to the month of the sale.
5% of the sales of each month was created in the second month of the sale. Because 2.75% is uncollectible, 2.75% is co-productive.
PURCHASES OF GOODS FOR SALES
Sales projections affect purchases equally. These represent 50% of the projected unified sales. They are purchased during the month of the sale and offered within the same month with a cash discount.
MONTHLY DISBURSEMENTS FOR EXPENDITURE AND PRINCIPAL OF DEBTS
EXPENSES:
WAGES 24.5% OF MONTHLY SALES COMMISSIONS $ 2% IN THE PROJECTED SALES EACH MONTH MORE THAN 3.5% OF THE MONTHLY COLLECTED NOMINAS 10.9% OF WHAT WAS PAID IN WAGES AND COMMISSIONS UTILITIES $ 55,000 MONTHLY INTERESTS 6.5% YEARLY OF THE BALANCE SHEET OF THE PRINCIPAL A DIVISION MONTHLY TO APPLY TO THE MORTGAGE 12% ANNUAL OF THE BALANCE OF THE MAIN ONE DIVISION MONTHLY TO APPLY TO THE OTHERS
MAIN DEBTS:
MORTGAGES $ 450,000 OF MAIN TOTAL WITH MONTHLY PRINCIPAL PAYMENTS OF $ 10,000.
OTHER DEBTS $ 500,000 OF MAIN TOTAL WITH MONTHLY PRINCIPAL PAYMENTS OF $ 5,000.
REQUIRED PREPARE THE FOLLOWING BUDGETS FOR 2014:
1. SALES AND CHARGES BUDGET 2. BUDGET OF PURCHASES AND PAYMENTS OF PURCHASES 3. BUDGET OF DISBURSEMENTS OF EXPENDITURE AND DEBTS 4. CASH BUDGET. to. BALANCE AT THE BEGINNING IS $ 0.00 second. MINIMUM EQUILIBRIUM DESIRED $ 50,000 MONTHLY 5. IN THE CASE OF THE NEED FOR FINANCING, TO COMPLY WITH THE DEFICIENCY OF CASH FOR THE MONTH AND THE BALANCE POLICIES OF THE COMPANY, THIS WILL ACCUMULATE 10% SIMPLE INTEREST FOR THE BALANCE AND TIME IN CIRCULATION. AS SOON AS EFFECTIVE IS AVAILABLE IN EXCESS TO THE MINIMUM BALANCE DESIRED.
NOTE; MAKE SURE THAT THE PRESENTATION IS IN ELECTRONIC SHEET FORMAT, EITHER EXCEL OR SIMILAR AND THAT IT IS ACCOMMODATED IN ONE (S) SHEET
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started