Question

Any help would be greatly appreciated!

The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and the activity for the year in total. Through connections at the Rotary Club, the CEO was able obtain a template for use in creating a master budget and has provided it to you along with financial information from the corporate controller. Your job is to create the following (This is all of the information that I was given. I would greatly appreciate any assistance, even if you can't answer everything!)

Breakeven analysis

                                                                         Variable cost per unit

Quantity	Label for Quantity	Price per 1 unit of quantity	Cost per finished goods unit	Description of cost
	hours per unit			Direct labor
	amt. of raw materials per unit			Direct materials
	DL hours per unit			Variable overhead
	Percentage of sales price			Variable selling & Admin. cost
	Percentage of sales price			Bad debts expense

Model Information

    Selling price (per unit)

    Variable costs

    Contribution margin

   

    Fixed S & A (Total fixed expense)

    Fixed overhead (Total fixed expense)

    Total fixed cost (Total fixed expense)

Table of Information for Graph Showing Breakeven Point

Units produced	Total cost	Revenue
0
4,000
8,000
12,000
16,000
20,000
24,000
28,000
32,000
36,000
40,000
44,000
48,000
52,000
56,000
60,000
64,000

Variable Costing Income Statement (for the year ending 12/31/18)

Revenue

Variable cost of goods sold

Variable selling and administrative

Bad debt expense

Contribution margin

Fixed manufacturing cost

Fixed selling and administrative

Operating income

Plus: Interest revenue

DATA

Input	4th quarter 2017	1st Quarter 2018	2nd quarter 2018	3rd quarter 2018	4th quarter 2018
Budgeted sales in units	43,000	37,900	34,500	31,000	43,000

Budgeted Selling Price: $530 per production unit (finished good)

Receivables:

     Receivables Collection Schedule: 91.5% quarter of sale; 5.5% Quarter following sale; 3.0% Uncollectible (entire projected uncollectible receivables are written off each quarter

Inventory Costs:

     Direct Labor 4.5 hours; $19.25 per direct labor hour

    

     Raw materials: 3 direct material units per finished good production unit; $85.00 per raw material unit

     Variable Overhead: $9.50 per direct labor hour

    

Fixed overhead:

           Depreciation: $320,000 per quarter

          Other fixed overhead: $950,000 per quarter

Fixed overhead Application Rate: Calculate from production budget

Inventory Accounts

Ending finished goods inventory in units	4th Quarter	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter
	0	15,000	19,000	20,000	15,000

Raw Materials Inventory

     Beginning Inventory (1/1/2018): 28,436 units

    Ending inventory of finished goods (1st quarter): 15,000 units

     Planned Ending Inventory: 26,000 units

     Policy: 25% of next quarters' needs for production is in ending raw materials inventory

Work In Progress Inventory

     Beginning Inventory (1/1/2018): $2,850

     Planned Ending Inventory: $2,850

Payment for Raw Materials

     Payment Policy: 85% Quarter of Purchase; 15% quarter following purchase

Operating Expenses

    Wages and Salaries Payment Policy: two times monthly on the 15th and 30th; fully paid each month

    Variable selling & Administrative Expenses: 3.50% of selling price

    Fixed selling & Administrative expenses

          Depreciation: $55,000 per quarter

          Other Selling & Admin. Exp. $180,000 per quarter

Capital Expenditures

     Equipment purchases: $5,450,000 end of 4th quarter

Treasury Activities

     Dividends to be declared: $400,000 per quarter

     Minimum cash balance: $250,000 required at end of every quarter

     Interest rate for investing (short-term): 4.0% annually; Interest policy- All of the ending cash balance for the quarter earns interest

     for the entire quarter. All of the ending cash balance for the quarter remains in Cash at the beginning of the next quarter.

     Interest rate for borrowing: 12% annually; interest policy- $10,000 increments are used in borrowing and repayment, maintaining

     the minimum cash balance. Borrowing occurs at the end of each quarter. Repayments occur at the end of the quarter.

Flexible Budget

    Actual Units Produced: First quarter: 43,000 units (use for flexible budget tab only)

    Flexible Budget: Production level 1: 45,000 units; Production level 2: 40,000 units

Diesel Dynamo Balance Sheet: Prior Year Results (12/31//17)

    Assets (Total: $44,348,000)

        Cash: $6,150,000

        Inventory: $3,748,000

        Accounts receivable (Net): $5,050,000

        Plant and equipment: $29,400,000

   Liabilities and Equity (Total: $44,348,000)

        Accounts Payable: $8,100,000

        Common Stock: $26,234,500

        Retained Earnings: $10,013,500

Answer 1

Answer The ompany high ech d Sbnyskm Porodevclioin Prod accessories uck and haspot Units Produc Actual produiA6Sumed ataal devel -o level -45000 Feible budget level budget Feubla ined aterials Casks 2 55 Unik Actual produclo Assumed ataal v 75000 Flonib budgetavel Fexi ble budet level () lo200 ooo

Vaniable ovehead 42.150 Acual pmoducloAssumed acbal level 43000 X42. 15 18 38250 Flexibla budg evd 45000 X 2.75 - 1923150 ఒ6b00 Flexible budget deved ) 1000O Tobal Vanial onoduction ast Onct (ost 384,3a Toal Adal aduct Assumed actaad lavel Vasriabl prcdut Cas1628125 Veriable praluela abbudd Leved -1296875

Totl Vooicble Producko Cast Flexible budget leel ) L0000t lo20000 3Le65000t 1910000 5 375000 Fixed (ost Actunl productson fAssumed actual level 320000950000 Flexible budgel levl 12700o0 Flexib budget evd (2) - 1270000 Totul dgd oduction Cost Actual poduclfassumed actualeve 1798125

Fleible budge evel t296875t 127000 5668 15 Flerible budgtleve 2)- 15345 000t 1 2700 o 664 5000