50.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer