Question
BUDGET INFORMATION Below is information on the financial results of the Company Caribe Supplies Inc. This information over the projections presented will be the basis
BUDGET INFORMATION
Below is information on the financial results of the Company Caribe Supplies Inc. This information over the projections presented will be the basis for planning and preparing budgets for next year.
MONTHLY SALES DURING THE PAST YEAR 2014
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 company plans an estimated 15% increase in sales reported during the months of last year are appropriate.
PROJECTING THE CHARGES BEING OF SALES AS FOLLOWS:
60% of sales are projected monthly charge during the same month. Due to a new collection policy will offer one and a half (11/2)% discount if customers pay within ten days from the invoice date. It is projected that 3/5 of customers are welcome to this term receivables.
20% of sales are projected to charge each month following the month of the sale month.
15% of sales each month are projected to charge two months following the month of sale.
5% sales charge each month projected three months following the month of sale. Because economic indicators and financial forecasts of the experts, you should consider this product projected recovery, 2.75% is uncollectible.
SHOPPING FOR GOODS SALES
Sales projections equally affect purchases. These represent 50% of monthly sales projected. Purchased during the month of sale and are projected to pay within the same month with a two% cash discount.
MONTHLY EXPENSES AND EXPENDITURES FOR HOME OF DEBTS
EXPENSES:
WAGES 24.5% OF SALES MONTHLY
COMMISSIONS $ 2% IN PROJECTED MONTHLY SALES MORE THAN 3.5% CHARGED MONTHLY
PAYROLL 10.9% FROM THE PAID IN WAGES AND COMMISSIONS
UTILITIES $ 55,000 MONTHLY EARNINGS
INTEREST 6.5% ANNUAL INTEREST OF BALANCE OF HOME A DIVIDED TO IMPLEMENT A MONTHLY
MORTGAGE
12% ANNUAL PRINCIPAL BALANCE OF A DIVIDED MONTHLY TO APPLY TO THE OTHER
HOME OF DEBTS:
MORTGAGE $ 450,000 PAYMENT OF TOTAL MONTHLY HOME HOME OF $ 10,000.
OTHER DEBTS $ 500,000 HOME WITH TOTAL MONTHLY PAYMENTS OF PRINCIPAL OF $ 5,000.
REQUIRED PREPARE FOR NEXT BUDGETS 2014:
1. BUDGET OF SALES AND COLLECTIONS
2. BUDGET FOR PURCHASES AND PAYMENTS SHOPPING
3. BUDGET EXPENDITURES OF EXPENSES AND LIABILITIES
4. CASH BUDGET.
a. BALANCE AT THE BEGINNING IS $ 0.00
b. DESIRED MINIMUM BALANCE $ 50,000 MONThly
5. IF NEED FINANCING TO MEET THE DEFICIENCY OF CASH FOR THE MONTH AND POLICIES OF THE COMPANY BALANCE OF THIS BUILD A 10% INTEREST FOR SIMPLE AND TIME OUTSTANDING BALANCE. AS SOON CASH BALANCE OVER THE DESIRED MINIMUM PROVIDED.
NOTE; BE SURE THE PRESENTATION IN ELECTRONIC FORMAT SHEET WHETHER OR SIMILAR AND EXCEL that fits ON A (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