This question has a lot packed into it. It's apart of a big excel project that I've completed but it just doesn't look right.

Broncos Corp. manufactures wooden frames with bronco medallion for framing the college degrees awarded by Western Michigan University. Each Bronco frame sells for $150 and requires:

• 5 linear feet of special Oak wood that costs $4.00 per foot
• Other direct material package (each package includes one Bronco Medallion, a glass face, and a cardboard cutout) that costs $25 each package (bought from an outside supplier)
• 30 minutes of labor hours to build (Labor cost averages $15.00 per hour)

Bronco Corp. has the following inventory policies:

• Ending finished goods inventory should be 25% of next months sales.
• Ending inventory of Oak wood should be 30% of next months production need.
• Ending inventory of other direct material package should be 20% of next months production need. (the supply chain for the other direct material packages is quite efficient and therefore, company maintains a smaller inventory of these packages as compared to Oak wood inventory)

As per the Marketing and Sales department of the Bronco Corp., sales are high in the month of graduation and the month following the graduation during Fall and Spring each year. Therefore, months of December, January, April, and May are considered high demand months. In a November budget meeting of the current year, the Sales Manager provided following estimates of unit sales for the upcoming months (December current year May next year):

December 2,000 frames

January 1,500 frames

February 800 frames

March 760 frames

April 2,100 frames

May 1,800 frames

Variable manufacturing overhead is incurred at a rate of $12.50 per frame produced. Annual fixed manufacturing overhead is estimated to be $300,000 ($25,000 per month) for expected production of 20,000 frames for the year. Fixed selling and administrative expenses are estimated at $31,000 per month and variable selling and administrative expenses are estimated at $15.00 per unit sold.

Of its sales each month, 80% is collected in the same month and remaining 20% in the month following the sales. This

Of the purchase of Oak wood, 60% is paid for during the month of purchase and remaining 40% is paid in the following month. Budgeted Oak wood purchase for December is $34,200. Other direct material package purchases are all paid for in the month of purchase itself. Also, all other operating costs are paid during the month incurred. Monthly fixed manufacturing overhead includes $5,000 in depreciation. During January, Bronco Corp. plans to pay $110,000 for a piece of equipment to replace an old equipment.

Bronco had $61,000 cash on hand on January 1. The company has a policy to maintain a monthly minimum cash balance of $50,000. The company may borrow any amount using the credit line provided by their bank to pay for deficits and maintain the minimum required balance of cash. Borrowings or any part of the borrowings may be paid off in the month there is excess cash available (Ignore interest on borrowings).

1. Using the information provided above prepare the following budgets for the first quarter (January - March) for Bronco Corporation. Include each month and quarter 1 total for each budget.
   1. Sales budget
   2. Production budget
   3. Direct Materials budgets (Hint: You will need TWO Direct Material Purchases budgets one for the Oak wood and another for the Direct Material Package.)
   4. Direct labor budget
   5. Manufacturing Overheads budget
   6. Budgeted Cost of Goods Sold (COGS)
   7. Selling and administrative expenses budget
2. Prepare Broncos budgeted income statement for quarter 1.
3. Prepare the following for Bronco for quarter 1:
   1. Budgeted cash receipts/collection each month (including quarter 1 total)
   2. Budgeted cash payments each month (including quarter 1 total)
   3. Cash budget of Bronco for quarter 1.
4. After completing requirements 1-3 above revise the budget spreadsheet to include following changes:

Bronco Corp. is contemplating to increase the selling price of the frames by 10% during the high sales months (graduation months) of December- January and April-May. The management of Bronco believes that it would affect unit sales marginally only, thereby, reducing unit sales by 5% in those months. How would these two changes affect the income of Quarter 1? Based on the analysis, should Bronco Corp. increase the price of frames temporarily during those high demand months? Include a short explanation in Excel file itself.

(You need to revise your Excel spreadsheet to determine the effect on income statement. If you used your formulas correctly for requirements 1-3, you will not need to make whole lot of changes to your spreadsheet).

What I need to know is whether or not the 2 DM budgets have as much of an impact on the cash budget. I've attached what I've done and again, sorry for this intense compact problem. I'm done weith the first 3 requirements and its due tonight Sun March 21st at 11:59. It's last-last minute but whatever help anyone can give I'd greatly appreciate it.

Ermemer Al Salg Sales Budget (frames December 2000 January Feburary 1500 800 March 750 May 1800 Daurier 1 3.000.00 Sales Budget/Month Hequirement Rated Income Statement ruary Feburary March 225.000,00 120100000 14.600.00 $ 2.500.000 $ 144.000 41.500.000 $ 142,500.00 $ 75,000.00 $ 72,200.00 $(53,500.00 143.000.00 $ 42,400.00 $ 89,000.00 $ 33,000 00$ 29,800.00 Balgeed Sales Revenue Less: Budgeted CDGS Budgeted GM Less Budgeted SA EXP Budgeted NOI 2100 December January Feburary March Budgetunk sales 2000 1500 500 750 Budget sales price 50.00 50.00 50.00 50.00 Backet sales revenue S 900,000.00 $225.000.00 $120,000.00 $114.000.00 $ $ Requirements 3.060.00 150.00 459.000.00 Bacted Sales Revenge Quarter 1 $ 459poo 00 Gaurler 1 350.00 Budad can cop December January Faturary March $800,000.00 $ 225,000.00 $ 120.000 cc $ 114,000.00 $ 180,000.00 $ 96.000.00 $ 1.200.00 $ M1000.00 45 74.000.000 > $ $ 367,200.00 1290 $ 80%.coctadis month FITXcodected next month Credt Sales Budgeted Cash Recipes 915.00 $ 240,000.00 $ 141.000.00 $ 115,200.00 S $ 195.200 00 $ 5 1765.000 3.210.00 Quarter 1 Gaurse 1 $ $ 68,400.00 $ 41.04000 $ 30,048 00 $ $1,25000 $ 179,550 $ 2319.375 00 3210.00 Tot. Budgeted Cash Payments December January Feburary March Budgeted Direct Matures Purchase Car Wood $ 34,200.00 23,200.00 $ 17,630.00 $ 27480.00 Paid in month of purchase 60% $ 13,974.00 S 10,578005 16 481.00 First month folosind purchase(4042 $ 13.680.00 $ 9,316.00 $ 7052.00 s 30450.00 21,275.00 $12.005.00 Direct labor $ 34175.00 VASCO 15.00 Manufacturing Overhead $ $ $ 1079687,50 S 770312 50 5 409 375.00 LessMonth Deprecation ($5.000 $ I55.000 SS DOO $) Salyand Admin Expanses $ 61,000.00 $ 53,500.00 43000.00 Purchase of Eupen und $110.000.000 Tot and Cash Priments $1,216.019 WA.X 91903 $ 16850.00 $ 5865.00 $ 115,000.00 > $ 5 14.815.00) 17,100.00 4.00 $ 157,500.00 $ 110 11000000 $ 290626.000 34,700.00 am 0 Cash Budget December Gaurter 1 $ 3210.00 Beginning CashBalance Pus: Budgeted Cash Receipts Less: Bulgatadas Payments Preliminary Cah bulance January Feburary March 61.000 50000 50000 $ 240,000.00 $ 141,000.00 $ 115 200.00 5(1,388 166.50) S 1919.606.50 $ 1598.490.00) (1716.50 $ 20 $ 1413390.00 Quarter 1 61,000 $ 496,200.00 $ 12.905,263.001 $123 $ 161150.00 S 782.00 Cash borrowed repaid min: 50.000 $ 1.137.165.50 $778.606.50 $ 453.290.00 $ 2,399063 00 B Production December Feburary March May gatun 2X 1500 DO 760 2000 1800 Pundy Fan Gehl 25% of next months S. 22.00 Les Beg Fin Goods Inv. 25% of current monthless 150MLS FREILS POLLS A LES 10.00 1525.01 TEAM Budgets production s 1,875.00 S 1325.00$ 790.00 $ 1.095.00 $ 2,025.00 Direct Material Budgets 1. Oak Wood December January Feburary March Cak Wood Harga duction s 1879.00 $ 1825.00 $ 250.00 1095.00 $ 2.500 1800.00 xDirect material regalements Intfunt Totaldirect materiale de fortion S9375.00S 625.005 395000 S 5475.00 $ 19.125.00 Plus Ending direct materiaisinventory 30% of next month production need 1,967.90 $ 1.185.00 $ 1.642.50 $ 3.037.50 $ Les Bract matariestory (30% of current month production 128512 2.50 S S.OLS 1.5.0 Tersal surchaus direct materiah S 550.00 S S 23.50 4.40 50 60.00 Conto direct mattis (54 AL 24.00 Budgeted cost of direct material purchases $ 34,200.00 $ 2.290.00 5 17.630.00 $ 27180.00 $ 2. Package December January Feburary March Lont Package Budgeted production $ S 1875.00 S 1.325.00 $790.00 $ 1.095.00 $ 2,025.00 xDirect material requirements Totalcimwerhed for action $ S 185.00 1925.00 $280.00 100.00 $ 2,025.00 Plus Ending drect materials inventory 2010 next month production needs. $ 265.00 $ 158.00 219.00 $ 405.00 Less: Beginning direct materiaisimestory (20% of current mon production needs IZS.NL PGS. 1. 1.0 Tural surchases of dret materials 1,765.00 $ 1218.00 $ 851.00 $ 1.181.00 Cont of direct marka/pukarel* 21.02.10 predst of direct materapurtham S14,175.00$ mex0.00 $ 21,375.00 $ 200.00 b) Direct latert December ry Feburary March fpari Budgeted production $ 1,250.00 $ 7950.00 $ 474000 $ 6570.00 $ 12.150 00 Direct Labor requirements( 50 hours 05 AS ALS 05 05 Tot DL Hours Req 5.625.00 S 3975.00 $ 2,370.00 $ 3.285.00 $ 5.075.00 15.00 DLS 59.25.000.00 Tel. Bud. DL $ 34,375.00 S 59.625.00 $ 35,550.00 $49.275.00 $ 91,125.00 E) MOH December January Feburary March April Totalcata dictator S34375.00 $ 59525.0035,550.00 49375.00 $ 91,125.00 Variatie CHate (12 strame But, war Manufacturing OH $1054687.50 $76531250 5446,375.00 $615937.50 tot Plus: Bud. Fk Manufacturing oH$25.00 200.000 25.09.2015 25.06.CO Bud. MOH S1.079,587.50 S 770312.50 $469,375.00 $640937.50 totes Fl Bud COGS December January Feburary March Agd Budgetedunk sales 2000 1500 500 400 750 Bayed $ / unit 355.0 SS5.00 $65.00 455.00 SS. RCOGS $ $150,000.00 $ 2.500.00 $44,200.00 $4100.00 $115 Socco G) Swing and Admin Esper December January Fabry March April Hargeted Sales $ $$ 7,000.00 1,900.00 VIX VarielExpl$15 15. 15.00 Bud. Var_Se amin C pense $ 30,000.00 $ 22,500.00 $ 12,000.00 $ 1.400.00 Fx Admin Exp (31.000/month $21.00.0000 30000 30000 Bud. Sel Admin Exp 5 3900.00 $ 43,000.00 $ 42400.00 $ 138,500.00 E di Cash Babice 5 50,000.00 $ 50,000.00 50.000.00 S150,000.00 $ $ $ 1642.00) 16.190.00 25.00 KITIMONI $ Gurter 1 19.260.00 0.5 9.630.00 15.00 344450.00 $ $ Gaurier 1 $ 144450.00 $ 12.50 $ 1805 125.00 $ 25.000.00 s 1830625.00 2100 Gaurter 1 3060 55.00 1,300.00 $ $ 5 $ 5 5 Qurler 1 001 15.00 45.900.00 31.000.00 76.900.00 Ermemer Al Salg Sales Budget (frames December 2000 January Feburary 1500 800 March 750 May 1800 Daurier 1 3.000.00 Sales Budget/Month Hequirement Rated Income Statement ruary Feburary March 225.000,00 120100000 14.600.00 $ 2.500.000 $ 144.000 41.500.000 $ 142,500.00 $ 75,000.00 $ 72,200.00 $(53,500.00 143.000.00 $ 42,400.00 $ 89,000.00 $ 33,000 00$ 29,800.00 Balgeed Sales Revenue Less: Budgeted CDGS Budgeted GM Less Budgeted SA EXP Budgeted NOI 2100 December January Feburary March Budgetunk sales 2000 1500 500 750 Budget sales price 50.00 50.00 50.00 50.00 Backet sales revenue S 900,000.00 $225.000.00 $120,000.00 $114.000.00 $ $ Requirements 3.060.00 150.00 459.000.00 Bacted Sales Revenge Quarter 1 $ 459poo 00 Gaurler 1 350.00 Budad can cop December January Faturary March $800,000.00 $ 225,000.00 $ 120.000 cc $ 114,000.00 $ 180,000.00 $ 96.000.00 $ 1.200.00 $ M1000.00 45 74.000.000 > $ $ 367,200.00 1290 $ 80%.coctadis month FITXcodected next month Credt Sales Budgeted Cash Recipes 915.00 $ 240,000.00 $ 141.000.00 $ 115,200.00 S $ 195.200 00 $ 5 1765.000 3.210.00 Quarter 1 Gaurse 1 $ $ 68,400.00 $ 41.04000 $ 30,048 00 $ $1,25000 $ 179,550 $ 2319.375 00 3210.00 Tot. Budgeted Cash Payments December January Feburary March Budgeted Direct Matures Purchase Car Wood $ 34,200.00 23,200.00 $ 17,630.00 $ 27480.00 Paid in month of purchase 60% $ 13,974.00 S 10,578005 16 481.00 First month folosind purchase(4042 $ 13.680.00 $ 9,316.00 $ 7052.00 s 30450.00 21,275.00 $12.005.00 Direct labor $ 34175.00 VASCO 15.00 Manufacturing Overhead $ $ $ 1079687,50 S 770312 50 5 409 375.00 LessMonth Deprecation ($5.000 $ I55.000 SS DOO $) Salyand Admin Expanses $ 61,000.00 $ 53,500.00 43000.00 Purchase of Eupen und $110.000.000 Tot and Cash Priments $1,216.019 WA.X 91903 $ 16850.00 $ 5865.00 $ 115,000.00 > $ 5 14.815.00) 17,100.00 4.00 $ 157,500.00 $ 110 11000000 $ 290626.000 34,700.00 am 0 Cash Budget December Gaurter 1 $ 3210.00 Beginning CashBalance Pus: Budgeted Cash Receipts Less: Bulgatadas Payments Preliminary Cah bulance January Feburary March 61.000 50000 50000 $ 240,000.00 $ 141,000.00 $ 115 200.00 5(1,388 166.50) S 1919.606.50 $ 1598.490.00) (1716.50 $ 20 $ 1413390.00 Quarter 1 61,000 $ 496,200.00 $ 12.905,263.001 $123 $ 161150.00 S 782.00 Cash borrowed repaid min: 50.000 $ 1.137.165.50 $778.606.50 $ 453.290.00 $ 2,399063 00 B Production December Feburary March May gatun 2X 1500 DO 760 2000 1800 Pundy Fan Gehl 25% of next months S. 22.00 Les Beg Fin Goods Inv. 25% of current monthless 150MLS FREILS POLLS A LES 10.00 1525.01 TEAM Budgets production s 1,875.00 S 1325.00$ 790.00 $ 1.095.00 $ 2,025.00 Direct Material Budgets 1. Oak Wood December January Feburary March Cak Wood Harga duction s 1879.00 $ 1825.00 $ 250.00 1095.00 $ 2.500 1800.00 xDirect material regalements Intfunt Totaldirect materiale de fortion S9375.00S 625.005 395000 S 5475.00 $ 19.125.00 Plus Ending direct materiaisinventory 30% of next month production need 1,967.90 $ 1.185.00 $ 1.642.50 $ 3.037.50 $ Les Bract matariestory (30% of current month production 128512 2.50 S S.OLS 1.5.0 Tersal surchaus direct materiah S 550.00 S S 23.50 4.40 50 60.00 Conto direct mattis (54 AL 24.00 Budgeted cost of direct material purchases $ 34,200.00 $ 2.290.00 5 17.630.00 $ 27180.00 $ 2. Package December January Feburary March Lont Package Budgeted production $ S 1875.00 S 1.325.00 $790.00 $ 1.095.00 $ 2,025.00 xDirect material requirements Totalcimwerhed for action $ S 185.00 1925.00 $280.00 100.00 $ 2,025.00 Plus Ending drect materials inventory 2010 next month production needs. $ 265.00 $ 158.00 219.00 $ 405.00 Less: Beginning direct materiaisimestory (20% of current mon production needs IZS.NL PGS. 1. 1.0 Tural surchases of dret materials 1,765.00 $ 1218.00 $ 851.00 $ 1.181.00 Cont of direct marka/pukarel* 21.02.10 predst of direct materapurtham S14,175.00$ mex0.00 $ 21,375.00 $ 200.00 b) Direct latert December ry Feburary March fpari Budgeted production $ 1,250.00 $ 7950.00 $ 474000 $ 6570.00 $ 12.150 00 Direct Labor requirements( 50 hours 05 AS ALS 05 05 Tot DL Hours Req 5.625.00 S 3975.00 $ 2,370.00 $ 3.285.00 $ 5.075.00 15.00 DLS 59.25.000.00 Tel. Bud. DL $ 34,375.00 S 59.625.00 $ 35,550.00 $49.275.00 $ 91,125.00 E) MOH December January Feburary March April Totalcata dictator S34375.00 $ 59525.0035,550.00 49375.00 $ 91,125.00 Variatie CHate (12 strame But, war Manufacturing OH $1054687.50 $76531250 5446,375.00 $615937.50 tot Plus: Bud. Fk Manufacturing oH$25.00 200.000 25.09.2015 25.06.CO Bud. MOH S1.079,587.50 S 770312.50 $469,375.00 $640937.50 totes Fl Bud COGS December January Feburary March Agd Budgetedunk sales 2000 1500 500 400 750 Bayed $ / unit 355.0 SS5.00 $65.00 455.00 SS. RCOGS $ $150,000.00 $ 2.500.00 $44,200.00 $4100.00 $115 Socco G) Swing and Admin Esper December January Fabry March April Hargeted Sales $ $$ 7,000.00 1,900.00 VIX VarielExpl$15 15. 15.00 Bud. Var_Se amin C pense $ 30,000.00 $ 22,500.00 $ 12,000.00 $ 1.400.00 Fx Admin Exp (31.000/month $21.00.0000 30000 30000 Bud. Sel Admin Exp 5 3900.00 $ 43,000.00 $ 42400.00 $ 138,500.00 E di Cash Babice 5 50,000.00 $ 50,000.00 50.000.00 S150,000.00 $ $ $ 1642.00) 16.190.00 25.00 KITIMONI $ Gurter 1 19.260.00 0.5 9.630.00 15.00 344450.00 $ $ Gaurier 1 $ 144450.00 $ 12.50 $ 1805 125.00 $ 25.000.00 s 1830625.00 2100 Gaurter 1 3060 55.00 1,300.00 $ $ 5 $ 5 5 Qurler 1 001 15.00 45.900.00 31.000.00 76.900.00 Ermemer Al Salg Sales Budget (frames December 2000 January Feburary 1500 800 March 750 May 1800 Daurier 1 3.000.00 Sales Budget/Month Hequirement Rated Income Statement ruary Feburary March 225.000,00 120100000 14.600.00 $ 2.500.000 $ 144.000 41.500.000 $ 142,500.00 $ 75,000.00 $ 72,200.00 $(53,500.00 143.000.00 $ 42,400.00 $ 89,000.00 $ 33,000 00$ 29,800.00 Balgeed Sales Revenue Less: Budgeted CDGS Budgeted GM Less Budgeted SA EXP Budgeted NOI 2100 December January Feburary March Budgetunk sales 2000 1500 500 750 Budget sales price 50.00 50.00 50.00 50.00 Backet sales revenue S 900,000.00 $225.000.00 $120,000.00 $114.000.00 $ $ Requirements 3.060.00 150.00 459.000.00 Bacted Sales Revenge Quarter 1 $ 459poo 00 Gaurler 1 350.00 Budad can cop December January Faturary March $800,000.00 $ 225,000.00 $ 120.000 cc $ 114,000.00 $ 180,000.00 $ 96.000.00 $ 1.200.00 $ M1000.00 45 74.000.000 > $ $ 367,200.00 1290 $ 80%.coctadis month FITXcodected next month Credt Sales Budgeted Cash Recipes 915.00 $ 240,000.00 $ 141.000.00 $ 115,200.00 S $ 195.200 00 $ 5 1765.000 3.210.00 Quarter 1 Gaurse 1 $ $ 68,400.00 $ 41.04000 $ 30,048 00 $ $1,25000 $ 179,550 $ 2319.375 00 3210.00 Tot. Budgeted Cash Payments December January Feburary March Budgeted Direct Matures Purchase Car Wood $ 34,200.00 23,200.00 $ 17,630.00 $ 27480.00 Paid in month of purchase 60% $ 13,974.00 S 10,578005 16 481.00 First month folosind purchase(4042 $ 13.680.00 $ 9,316.00 $ 7052.00 s 30450.00 21,275.00 $12.005.00 Direct labor $ 34175.00 VASCO 15.00 Manufacturing Overhead $ $ $ 1079687,50 S 770312 50 5 409 375.00 LessMonth Deprecation ($5.000 $ I55.000 SS DOO $) Salyand Admin Expanses $ 61,000.00 $ 53,500.00 43000.00 Purchase of Eupen und $110.000.000 Tot and Cash Priments $1,216.019 WA.X 91903 $ 16850.00 $ 5865.00 $ 115,000.00 > $ 5 14.815.00) 17,100.00 4.00 $ 157,500.00 $ 110 11000000 $ 290626.000 34,700.00 am 0 Cash Budget December Gaurter 1 $ 3210.00 Beginning CashBalance Pus: Budgeted Cash Receipts Less: Bulgatadas Payments Preliminary Cah bulance January Feburary March 61.000 50000 50000 $ 240,000.00 $ 141,000.00 $ 115 200.00 5(1,388 166.50) S 1919.606.50 $ 1598.490.00) (1716.50 $ 20 $ 1413390.00 Quarter 1 61,000 $ 496,200.00 $ 12.905,263.001 $123 $ 161150.00 S 782.00 Cash borrowed repaid min: 50.000 $ 1.137.165.50 $778.606.50 $ 453.290.00 $ 2,399063 00 B Production December Feburary March May gatun 2X 1500 DO 760 2000 1800 Pundy Fan Gehl 25% of next months S. 22.00 Les Beg Fin Goods Inv. 25% of current monthless 150MLS FREILS POLLS A LES 10.00 1525.01 TEAM Budgets production s 1,875.00 S 1325.00$ 790.00 $ 1.095.00 $ 2,025.00 Direct Material Budgets 1. Oak Wood December January Feburary March Cak Wood Harga duction s 1879.00 $ 1825.00 $ 250.00 1095.00 $ 2.500 1800.00 xDirect material regalements Intfunt Totaldirect materiale de fortion S9375.00S 625.005 395000 S 5475.00 $ 19.125.00 Plus Ending direct materiaisinventory 30% of next month production need 1,967.90 $ 1.185.00 $ 1.642.50 $ 3.037.50 $ Les Bract matariestory (30% of current month production 128512 2.50 S S.OLS 1.5.0 Tersal surchaus direct materiah S 550.00 S S 23.50 4.40 50 60.00 Conto direct mattis (54 AL 24.00 Budgeted cost of direct material purchases $ 34,200.00 $ 2.290.00 5 17.630.00 $ 27180.00 $ 2. Package December January Feburary March Lont Package Budgeted production $ S 1875.00 S 1.325.00 $790.00 $ 1.095.00 $ 2,025.00 xDirect material requirements Totalcimwerhed for action $ S 185.00 1925.00 $280.00 100.00 $ 2,025.00 Plus Ending drect materials inventory 2010 next month production needs. $ 265.00 $ 158.00 219.00 $ 405.00 Less: Beginning direct materiaisimestory (20% of current mon production needs IZS.NL PGS. 1. 1.0 Tural surchases of dret materials 1,765.00 $ 1218.00 $ 851.00 $ 1.181.00 Cont of direct marka/pukarel* 21.02.10 predst of direct materapurtham S14,175.00$ mex0.00 $ 21,375.00 $ 200.00 b) Direct latert December ry Feburary March fpari Budgeted production $ 1,250.00 $ 7950.00 $ 474000 $ 6570.00 $ 12.150 00 Direct Labor requirements( 50 hours 05 AS ALS 05 05 Tot DL Hours Req 5.625.00 S 3975.00 $ 2,370.00 $ 3.285.00 $ 5.075.00 15.00 DLS 59.25.000.00 Tel. Bud. DL $ 34,375.00 S 59.625.00 $ 35,550.00 $49.275.00 $ 91,125.00 E) MOH December January Feburary March April Totalcata dictator S34375.00 $ 59525.0035,550.00 49375.00 $ 91,125.00 Variatie CHate (12 strame But, war Manufacturing OH $1054687.50 $76531250 5446,375.00 $615937.50 tot Plus: Bud. Fk Manufacturing oH$25.00 200.000 25.09.2015 25.06.CO Bud. MOH S1.079,587.50 S 770312.50 $469,375.00 $640937.50 totes Fl Bud COGS December January Feburary March Agd Budgetedunk sales 2000 1500 500 400 750 Bayed $ / unit 355.0 SS5.00 $65.00 455.00 SS. RCOGS $ $150,000.00 $ 2.500.00 $44,200.00 $4100.00 $115 Socco G) Swing and Admin Esper December January Fabry March April Hargeted Sales $ $$ 7,000.00 1,900.00 VIX VarielExpl$15 15. 15.00 Bud. Var_Se amin C pense $ 30,000.00 $ 22,500.00 $ 12,000.00 $ 1.400.00 Fx Admin Exp (31.000/month $21.00.0000 30000 30000 Bud. Sel Admin Exp 5 3900.00 $ 43,000.00 $ 42400.00 $ 138,500.00 E di Cash Babice 5 50,000.00 $ 50,000.00 50.000.00 S150,000.00 $ $ $ 1642.00) 16.190.00 25.00 KITIMONI $ Gurter 1 19.260.00 0.5 9.630.00 15.00 344450.00 $ $ Gaurier 1 $ 144450.00 $ 12.50 $ 1805 125.00 $ 25.000.00 s 1830625.00 2100 Gaurter 1 3060 55.00 1,300.00 $ $ 5 $ 5 5 Qurler 1 001 15.00 45.900.00 31.000.00 76.900.00 Ermemer Al Salg Sales Budget (frames December 2000 January Feburary 1500 800 March 750 May 1800 Daurier 1 3.000.00 Sales Budget/Month Hequirement Rated Income Statement ruary Feburary March 225.000,00 120100000 14.600.00 $ 2.500.000 $ 144.000 41.500.000 $ 142,500.00 $ 75,000.00 $ 72,200.00 $(53,500.00 143.000.00 $ 42,400.00 $ 89,000.00 $ 33,000 00$ 29,800.00 Balgeed Sales Revenue Less: Budgeted CDGS Budgeted GM Less Budgeted SA EXP Budgeted NOI 2100 December January Feburary March Budgetunk sales 2000 1500 500 750 Budget sales price 50.00 50.00 50.00 50.00 Backet sales revenue S 900,000.00 $225.000.00 $120,000.00 $114.000.00 $ $ Requirements 3.060.00 150.00 459.000.00 Bacted Sales Revenge Quarter 1 $ 459poo 00 Gaurler 1 350.00 Budad can cop December January Faturary March $800,000.00 $ 225,000.00 $ 120.000 cc $ 114,000.00 $ 180,000.00 $ 96.000.00 $ 1.200.00 $ M1000.00 45 74.000.000 > $ $ 367,200.00 1290 $ 80%.coctadis month FITXcodected next month Credt Sales Budgeted Cash Recipes 915.00 $ 240,000.00 $ 141.000.00 $ 115,200.00 S $ 195.200 00 $ 5 1765.000 3.210.00 Quarter 1 Gaurse 1 $ $ 68,400.00 $ 41.04000 $ 30,048 00 $ $1,25000 $ 179,550 $ 2319.375 00 3210.00 Tot. Budgeted Cash Payments December January Feburary March Budgeted Direct Matures Purchase Car Wood $ 34,200.00 23,200.00 $ 17,630.00 $ 27480.00 Paid in month of purchase 60% $ 13,974.00 S 10,578005 16 481.00 First month folosind purchase(4042 $ 13.680.00 $ 9,316.00 $ 7052.00 s 30450.00 21,275.00 $12.005.00 Direct labor $ 34175.00 VASCO 15.00 Manufacturing Overhead $ $ $ 1079687,50 S 770312 50 5 409 375.00 LessMonth Deprecation ($5.000 $ I55.000 SS DOO $) Salyand Admin Expanses $ 61,000.00 $ 53,500.00 43000.00 Purchase of Eupen und $110.000.000 Tot and Cash Priments $1,216.019 WA.X 91903 $ 16850.00 $ 5865.00 $ 115,000.00 > $ 5 14.815.00) 17,100.00 4.00 $ 157,500.00 $ 110 11000000 $ 290626.000 34,700.00 am 0 Cash Budget December Gaurter 1 $ 3210.00 Beginning CashBalance Pus: Budgeted Cash Receipts Less: Bulgatadas Payments Preliminary Cah bulance January Feburary March 61.000 50000 50000 $ 240,000.00 $ 141,000.00 $ 115 200.00 5(1,388 166.50) S 1919.606.50 $ 1598.490.00) (1716.50 $ 20 $ 1413390.00 Quarter 1 61,000 $ 496,200.00 $ 12.905,263.001 $123 $ 161150.00 S 782.00 Cash borrowed repaid min: 50.000 $ 1.137.165.50 $778.606.50 $ 453.290.00 $ 2,399063 00 B Production December Feburary March May gatun 2X 1500 DO 760 2000 1800 Pundy Fan Gehl 25% of next months S. 22.00 Les Beg Fin Goods Inv. 25% of current monthless 150MLS FREILS POLLS A LES 10.00 1525.01 TEAM Budgets production s 1,875.00 S 1325.00$ 790.00 $ 1.095.00 $ 2,025.00 Direct Material Budgets 1. Oak Wood December January Feburary March Cak Wood Harga duction s 1879.00 $ 1825.00 $ 250.00 1095.00 $ 2.500 1800.00 xDirect material regalements Intfunt Totaldirect materiale de fortion S9375.00S 625.005 395000 S 5475.00 $ 19.125.00 Plus Ending direct materiaisinventory 30% of next month production need 1,967.90 $ 1.185.00 $ 1.642.50 $ 3.037.50 $ Les Bract matariestory (30% of current month production 128512 2.50 S S.OLS 1.5.0 Tersal surchaus direct materiah S 550.00 S S 23.50 4.40 50 60.00 Conto direct mattis (54 AL 24.00 Budgeted cost of direct material purchases $ 34,200.00 $ 2.290.00 5 17.630.00 $ 27180.00 $ 2. Package December January Feburary March Lont Package Budgeted production $ S 1875.00 S 1.325.00 $790.00 $ 1.095.00 $ 2,025.00 xDirect material requirements Totalcimwerhed for action $ S 185.00 1925.00 $280.00 100.00 $ 2,025.00 Plus Ending drect materials inventory 2010 next month production needs. $ 265.00 $ 158.00 219.00 $ 405.00 Less: Beginning direct materiaisimestory (20% of current mon production needs IZS.NL PGS. 1. 1.0 Tural surchases of dret materials 1,765.00 $ 1218.00 $ 851.00 $ 1.181.00 Cont of direct marka/pukarel* 21.02.10 predst of direct materapurtham S14,175.00$ mex0.00 $ 21,375.00 $ 200.00 b) Direct latert December ry Feburary March fpari Budgeted production $ 1,250.00 $ 7950.00 $ 474000 $ 6570.00 $ 12.150 00 Direct Labor requirements( 50 hours 05 AS ALS 05 05 Tot DL Hours Req 5.625.00 S 3975.00 $ 2,370.00 $ 3.285.00 $ 5.075.00 15.00 DLS 59.25.000.00 Tel. Bud. DL $ 34,375.00 S 59.625.00 $ 35,550.00 $49.275.00 $ 91,125.00 E) MOH December January Feburary March April Totalcata dictator S34375.00 $ 59525.0035,550.00 49375.00 $ 91,125.00 Variatie CHate (12 strame But, war Manufacturing OH $1054687.50 $76531250 5446,375.00 $615937.50 tot Plus: Bud. Fk Manufacturing oH$25.00 200.000 25.09.2015 25.06.CO Bud. MOH S1.079,587.50 S 770312.50 $469,375.00 $640937.50 totes Fl Bud COGS December January Feburary March Agd Budgetedunk sales 2000 1500 500 400 750 Bayed $ / unit 355.0 SS5.00 $65.00 455.00 SS. RCOGS $ $150,000.00 $ 2.500.00 $44,200.00 $4100.00 $115 Socco G) Swing and Admin Esper December January Fabry March April Hargeted Sales $ $$ 7,000.00 1,900.00 VIX VarielExpl$15 15. 15.00 Bud. Var_Se amin C pense $ 30,000.00 $ 22,500.00 $ 12,000.00 $ 1.400.00 Fx Admin Exp (31.000/month $21.00.0000 30000 30000 Bud. Sel Admin Exp 5 3900.00 $ 43,000.00 $ 42400.00 $ 138,500.00 E di Cash Babice 5 50,000.00 $ 50,000.00 50.000.00 S150,000.00 $ $ $ 1642.00) 16.190.00 25.00 KITIMONI $ Gurter 1 19.260.00 0.5 9.630.00 15.00 344450.00 $ $ Gaurier 1 $ 144450.00 $ 12.50 $ 1805 125.00 $ 25.000.00 s 1830625.00 2100 Gaurter 1 3060 55.00 1,300.00 $ $ 5 $ 5 5 Qurler 1 001 15.00 45.900.00 31.000.00 76.900.00