70.2K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer