Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Risk Assessment Made Easy Seeing What Others Miss

Authors: Charles Hall

1st Edition

0578961679, 978-0578961675

More Books

Students also viewed these Accounting questions

Question

Am I a member of many organizations?

Answered: 1 week ago