Hello PLEASE I REALLY need help with Milestone 3, I need to have it completed really soon.I have worked on Milestone 1 & 2, I have attached those for reference.

Acct 552 Course Project

(Master Budget Preparation)

You have been hired by the McClosky Corporation and they manufacture industrial dye. The company is preparing its 20X9 master budget and has presented you with the following information:

1. The projected December 31, 20X8, balance sheet for the company is as follows:

Assets

Cash $ 6,080

Accounts Receivable 29,500

Raw Materials Inventory 1,000

Finished Goods Inventory 3,200

Prepaid Insurance 1,800

Building $ 350,000

Accum Depreciation (25,000) 325,000

Total Assets $ 366,580

Liabilities and Equity

Notes Payable $ 25,000

Accounts Payable 2,650

Dividends Payable 12,000

Total Liabilities $ 39,650

Common Stock $ 200,000

Paid-In Capital 40,000

Retained Earnings 86,930 326,930

Total Liabilities and

Stockholders Equity $ 366,580

Other Information that is being provided to you:

2. The Accounts Receivable balance at 12/31/20X8 represents the balances of November and December credit sales. Sales were $90,000 and $85,000 respectively.
3. Estimated sales in gallons of dye for January through May 20X9 are as follows:

January 9,000

February 11,000

March 16,000

April 14,000

May 13,000

June 12,000

Each gallon of dye sells for $ 15

4. The collection pattern for accounts receivable is as follows: 70 percent in the month of sale, 20 percent in the first month after the sale, and 10 percent in the second month after the sale. McClosky does not provide cash discounts and they are not expecting any bad debts.
5. Each gallon of dye has the following standard quantities and costs for direct material and direct labor:

1.4 gallons of direct material (some evaporation takes place during processing) X $.90 per gallon $ 1.26

0.5 direct labor X $ 8 per hour 4.00

6. Variable overhead is applied to the product on a machine-hour basis. Processing one gallon of dye takes five hours of machine time. The variable overhead is $0.08 per machine hour. Variable overhead consists of utility costs. Total annual fixed overhead is $150,000; it is applied at $ 1 per gallon based on expected annual capacity of 150,000 gallons. Fixed overhead per year is made up of the following costs:

Salaries $ 110,000

Utilities 15,000

Insurance 1,800

Depreciation-factory 23,200

Fixed overhead is incurred evenly throughout the year.

7. There is no beginning Work-in-Process Inventory. All work is completed in the period in which it is started. Raw Material Inventory at the beginning of the year consists of 1,100 gallons of direct material at a standard cost of $.90 per gallon. There are 500 gallons of dye in Finished Goods Inventory at the beginning of the year carried at a standard cost of $6.28 per gallon; direct material, $.98, direct labor, $4.00; variable overhead $ .30; fixed overhead , $1,00
8. Accounts Payable relates to raw material and is paid 60 percent in the month of purchase and 40 percent in the month after purchase. No discounts are received for prompt payment.
9. The dividend will be paid in January 20X9.
10. A new piece of equipment will be purchased in March 20X9 and the cost is $12,000. Payment of 80 percent will be made in March and 20 percent in April. The equipment has a useful life of three years and will be placed in service on March 1.
11. The note payable has a 12 percent interest rate; interest is paid at the end of each month. The principle of the note is repaid as cash is available to do so.
12. The McClosky management team wishes to maintain a minimum cash balance of $5,500. Investments and borrowing are made in $100 amounts. (Even $100 amounts). Interest on any borrowings are expected to be 12 percent per year, and investments will earn 4 percent per year.
13. The ending finished goods inventory should include 5 percent of next months sales. This will not be true at the beginning of 20X9 due to a miscalculation in sales for the month of December. The ending inventory of raw materials should be 5 percent of next months needs.
14. Selling and administration costs per month are as follows: salaries $25,000; rent, $7,000 and utilities, $800. These costs are paid in cash as they are incurred.
15. The companys tax rate is 20 percent.

Please note: You will be preparing a master budget for the first quarter of 20X9 and the supporting schedules listed below:

Requirements:

Milestone 1:

Please prepare the following budgets:

1. Sales Budget
2. Production Budget
3. Purchases Budget

Please submit Milestone 1 at the end of Week 6.

Milestone 2:

Please prepare the following budgets:

4. Labor Budget
5. Variable Overhead Budget
6. Fixed Overhead Budget
7. Budgeted Cost of Goods Manufactured
8. Budgeted Income Statement

Please submit Milestone 2 at the end of Week 7.

Milestone 3:

1. Budgeted Balance Sheet

10. Cash Budget
11. Budget Presentation and please address the following questions:

1. The sales manager would like to increase the sales price by 10 next quarter, what will be the projected revenues be for the 2^nd quarter.
2. The production manager would like to purchase new equipment for next quarter due to the fact that their competitor has purchased equipment which cost $50,000. Will the company be able to make the purchase or will you need more information?
3. The CEO feels that the cash budget is not necessary, please explain to the CEO why cash budgeting is important to the organization.
4. Please explain the to the management team how a competitors actions can affect business planning.

Please submit Milestone 3 at the end of Week 8.

Milestone 1- Completed

Milestone 2- Completed

Need help with the last part, Milestone 3

Milestone 3:

1. Budgeted Balance Sheet
2. Cash Budget
3. Budget Presentation and please address the following questions:

1. The sales manager would like to increase the sales price by 10 next quarter, what will be the projected revenues be for the 2^nd quarter.
2. The production manager would like to purchase new equipment for next quarter due to the fact that their competitor has purchased equipment which cost $50,000. Will the company be able to make the purchase or will you need more information?
3. The CEO feels that the cash budget is not necessary, please explain to the CEO why cash budgeting is important to the organization.
4. Please explain the to the management team how a competitors actions can affect business planning.

Estimated Sales Selling Price/Dye Estimated Total Sales January 9,000 $ 15 $ 135,000 Sales Budget February March 11,000 16,000 $ 15 $ 15 $ 165,000 $240,000 April May June 14,000 13,000 12,000 $ 15 $ 15 $ 15 $ 210,000 $ 195,000 $180,000 June 12,000 Sales Desired Closing Inventory Required Inventory Opening Inventory Total Production January 9,000 550 9,550 500 9,050 Production Budget February March 11,000 16,000 800 700 11,800 16,700 550 800 11,250 15,900 April 14,000 650 14,650 700 13,950 May 13,000 600 13,600 650 12,950 12,000 600 11,400 June May 12,950 1.4 18,130 11,400 1.4 15,960 January 9,050 1.4 12,670 788 13,458 1,100 12,358 0.9 11,122 Total Production Raw Material/ Unit Total Material required Desired Closing Inventory Materials Required Opening Raw Materials Total Purchases Purchase Cost Per Unit Total Purchases Purchase Budget February March 11,250 15,900 1.4 1.4 15,750 22,260 1,113 977 16,863 23,237 788 1,113 16,076 22,124 0.9 0.9 14,468 19,911 798 April 13,950 1.4 19,530 907 20,437 977 19,460 0.9 17,514 18,928 907 18,022 0.9 16,219 15,960 798 15,162 0.9 13,646 Budgeted Production Units Hours needed/ unit Total hours needed Per hour rate Budgeted Labor Cost Labor Budget January February 9,050 11,250 0.50 0.50 4,525 5,625 8.00 8.00 36,200 45,000 March 15,900 0.50 7,950 8.00 63,600 April 13,950 0.50 6,975 8.00 55,800 May 12,950 0.50 6,475 8.00 51,800 June 11,400 0.50 5,700 8.00 45,600 Budgeted Production Units Hours needed/ unit Total hours needed Per hour rate Budgeted Variable Overhead Cost Variable Overhead Budget January February 9,050 11,250 5.00 5.00 45,250 56,250 0.08 3,620 4,500 March 15,900 5.00 79,500 0.08 6,360 April 13,950 5.00 69,750 0.08 5,580 May 12,950 5.00 64,750 0.08 5,180 June 11,400 5.00 57,000 0.08 4,560 0.08 Salaries Utilities Insurance Depreciation Budgeted Fixed Overhead Fixed Overhead Budget January February 9,167 9,167 1,250 1,250 150 150 1,933 1,933 12,500 12,500 March 9,167 1,250 150 1,933 12,500 April 9,167 1,250 150 1,933 12,500 May 9,167 1,250 150 1,933 12,500 June 9,167 1,250 150 1,933 12,500 Budgeted Cost of Goods Manufactured Per Unit Cost Per Unit Requirement 1.40 0.50 5.00 0.90 8.00 0.80 Direct Material Direct Labor Variable Fixed Manufacturing Cost/ unit # of units produced Budgeted Cost of Goods Manufactured Total Cost 1.26 4.00 0.40 1.00 6.66 36,200 241,092 540,000 Budgeted Income Statement Sales Revenue Less: Cost of Goods Sold Beginning Finished Goods Inventory Add: Cost of Goods Sold Manufactured Cost of Goods available for sales Less: Ending Finished Goods Inventory 4,662 Cost of Goods Gross Margin Less: Selling and Admin Expense 32,800 Net Income 3,200 241,092 244,292 (4,662) 239,630 300,370 (98,400) 201,970