How do I calculate the Diesel Dyanamo Budget Project?

After the budget committee meeting, you have been asked to make corrections noticed at the meeting (if any), and complete the master budget process by creating the following documents and analyses:

1. pro forma cost of goods manufactured

2. pro forma cost of goods sold both financial and variable cost basis

3. pro forma income statement (financial basis)

4. pro forma balance sheet

5. pro forma income statement (variable cost basis)

6. pro forma statement of retained earnings

7. breakeven analysis:breakeven sales level in units and dollars

   1. cost volume profit graph showing the breakeven point

8. flexible budget

   1. Create the flexible budget results for production costs as if actual production were 43,000 units in the first quarter of 2017.

   2. Add flexible budget results for slightly higher and slightly lower production at 45,000 units and 40,000 units, respectively.

Budget Project Student Template Fall 2017 DNP - Mic Acrobat View General 1 . Home Insert Page Layout Formulas Data Review Calibri - 10 AA == A Copy Paste BIU - DA Format Painter Ceboard Wrap Test Merge & Center ER % Cont 4. Agent Diesel Dynamo Company Budget Project Fall 2017 4 INPUT SECTION ad 3rd Quarter Quarter Quarter 2018 37.500 Quarter 2018 34,500 Quarter 2018 31000 Budgeted sales in units 43.000 43.000 Pudrated Selling Price 5530 per production unit Finished Good) 14 RECEIVABLES Receivables Collection Schedule 91.50% quarter of sale 550 Quarter following sale 3.00 uncollectible 100.00% Entire projected uncollectible receivables are written off each quarte Policy 1 INVENTORY COSTS Direct Labor 45 hours 19.50 per direct labor hour Materials 3 direct material units per finished god production unit 8500 bermaterial unit ASSIGNMENT FORMATION et OM SO H ASA DE 9 x 2W -- Budget Project Student Template Fall 2017 DNP Acrobat Home Insert Page Layout Formulas Data Review View - 10 -A General N = A' ESS Wrap Text Merge & Center U E $ % .. Calibri Copy Format Painter BI oard 012 - Font Alignment Number Variable Overhead 9.50 per Direct Labor Hour Fixed Overhead Depreciation Other Fixed Overhead 328,000 per quarter $950,000 per quarter Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET NVENTORY ACCOUNTS Ending Finished Goods Inventory 4th Quarter 1st Quarter 1 5.000 2nd Quarter 19.000 L 3rd Quarter 20.000 Quarter 15 cool Be n ventory /12018 Enton 28.436 units 25.000 units 25% of next sters' needs for production sin end n ow Materials inventory 2.850 2.350 Esc Budget Project Student Template Fall 2017 DNP - Microsoft Acrobat Home Insert Page Layout Formulas Data Review View - 10-AA Wrap Text General Calibri Copy Format Painter BTU pboard - A $ % . . Merge & Center Alignment Conditional Formatting Number 112 PERATING EXPENSES Wages and Salaries Dament Payment Policy 2 times monthly on the 15th and so Fully paid each month Variable Sec tive Exp 3.25 of selling price Ford Selling & Administrative Exp Other Selling Administrative Exp $55 000 per quarter $180.000 per quarter CAPTAL EXPENDITURES 55,450,000 end of th Quarter $400.000 eur $250.000 Ruined stend of every rest i ng short term 3 All of the ending chance for the of the chance th transvest for the entire quarter e cash at the beginning of the next ou 510.000 trements are used in borro r maintain the minimum cash baner Repryments occur on the end of the huarter Data Review Budget Project Student Template F Acrobat View 09. File Home Insert Page Layout Formulas X Cut Calibri - 10 -A N Copy Paste Format Painter B I U . 3- A Clipboard Font J12 Wrap Text General E Merge & Center - $ - % Alignment Number D 83 FLEXIBLE BUDGET Actual Units Produced First Quarter 43,000 units (use for Flexible Budget Tab only) Flexible Budget - Analyze at 2 Production Levels Production level 1 Production level 2 4 5,000 units 40,000 units PRIOR YEAR RESULTS Diesel Dynamo Company Balance Sheet 12/31/2017 ASSETS Cash Inventory Accounts Receivable (net) plant and Equipment $ $ 6.150.000 3,748,000 5,050,000 29,400,000 44 348.000 $ LIABILITIES AND EQUITY Accounts Payable Common Stock ned Earnings 5 104 105 8 .100.000 26,234,500 10013.500 44 348.000 $ 107 108 109 ASSIGNMENT INFORMATION S e t Production BO OM BOL Budget OH S SSA Exp Budget Budget Project Student Template Fall 2017 DNP - Mic Acrobat View General 1 . Home Insert Page Layout Formulas Data Review Calibri - 10 AA == A Copy Paste BIU - DA Format Painter Ceboard Wrap Test Merge & Center ER % Cont 4. Agent Diesel Dynamo Company Budget Project Fall 2017 4 INPUT SECTION ad 3rd Quarter Quarter Quarter 2018 37.500 Quarter 2018 34,500 Quarter 2018 31000 Budgeted sales in units 43.000 43.000 Pudrated Selling Price 5530 per production unit Finished Good) 14 RECEIVABLES Receivables Collection Schedule 91.50% quarter of sale 550 Quarter following sale 3.00 uncollectible 100.00% Entire projected uncollectible receivables are written off each quarte Policy 1 INVENTORY COSTS Direct Labor 45 hours 19.50 per direct labor hour Materials 3 direct material units per finished god production unit 8500 bermaterial unit ASSIGNMENT FORMATION et OM SO H ASA DE 9 x 2W -- Budget Project Student Template Fall 2017 DNP Acrobat Home Insert Page Layout Formulas Data Review View - 10 -A General N = A' ESS Wrap Text Merge & Center U E $ % .. Calibri Copy Format Painter BI oard 012 - Font Alignment Number Variable Overhead 9.50 per Direct Labor Hour Fixed Overhead Depreciation Other Fixed Overhead 328,000 per quarter $950,000 per quarter Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET NVENTORY ACCOUNTS Ending Finished Goods Inventory 4th Quarter 1st Quarter 1 5.000 2nd Quarter 19.000 L 3rd Quarter 20.000 Quarter 15 cool Be n ventory /12018 Enton 28.436 units 25.000 units 25% of next sters' needs for production sin end n ow Materials inventory 2.850 2.350 Esc Budget Project Student Template Fall 2017 DNP - Microsoft Acrobat Home Insert Page Layout Formulas Data Review View - 10-AA Wrap Text General Calibri Copy Format Painter BTU pboard - A $ % . . Merge & Center Alignment Conditional Formatting Number 112 PERATING EXPENSES Wages and Salaries Dament Payment Policy 2 times monthly on the 15th and so Fully paid each month Variable Sec tive Exp 3.25 of selling price Ford Selling & Administrative Exp Other Selling Administrative Exp $55 000 per quarter $180.000 per quarter CAPTAL EXPENDITURES 55,450,000 end of th Quarter $400.000 eur $250.000 Ruined stend of every rest i ng short term 3 All of the ending chance for the of the chance th transvest for the entire quarter e cash at the beginning of the next ou 510.000 trements are used in borro r maintain the minimum cash baner Repryments occur on the end of the huarter Data Review Budget Project Student Template F Acrobat View 09. File Home Insert Page Layout Formulas X Cut Calibri - 10 -A N Copy Paste Format Painter B I U . 3- A Clipboard Font J12 Wrap Text General E Merge & Center - $ - % Alignment Number D 83 FLEXIBLE BUDGET Actual Units Produced First Quarter 43,000 units (use for Flexible Budget Tab only) Flexible Budget - Analyze at 2 Production Levels Production level 1 Production level 2 4 5,000 units 40,000 units PRIOR YEAR RESULTS Diesel Dynamo Company Balance Sheet 12/31/2017 ASSETS Cash Inventory Accounts Receivable (net) plant and Equipment $ $ 6.150.000 3,748,000 5,050,000 29,400,000 44 348.000 $ LIABILITIES AND EQUITY Accounts Payable Common Stock ned Earnings 5 104 105 8 .100.000 26,234,500 10013.500 44 348.000 $ 107 108 109 ASSIGNMENT INFORMATION S e t Production BO OM BOL Budget OH S SSA Exp Budget