50.1K

Verified Solution

Link Copied!

DXB Electronics has recently approached you as a business consultant to assist them in preparing their 2023 budgets. They provided you with the following data: The company is manufacturing and selling two models of their branded Laptop: Expected number of units to be sold in 2023: Model 101: 30,000 units Model 202: 20,000 units Expected selling price per unit of each model: Model 101: $500 per unit Model 202: $400 per unit Each model requires five components to be produced: Camera (Model 101 has 2 Cameras, while Model 202 has only one Camera). Keypad Screen Frame Motherboard. Purchasing price per each component is as follows: Camera: $30 Keypads: $20 Frame: $6 o. Motherboard: $24 The policy of the company is zero ending inventory of any components and laptop models. Each laptop model requires 5.5 hours of labor to be manufactured at a cost of $10.00 per hour. Manufacturing overhead cost is allocated at a rate of $30 per direct labor hour. Selling and admin variable expense rates per unit of sales are: o Sales commissions $3 o Freight-out $2 Selling and admin fixed expenses for each model include: o Depreciation $8,000, o Salaries $2,000 o Maintenance $3000 Interest expense is $10,000 and corporate income tax is $50,000 Required: Prepare the following budgets: 1. Sales Budget 2. Production Budget 3. Direct Material Purchases Budget (you may prepare one budget per component) 4. Direct Labor Budget 5. Manufacturing Overhead Cost Budget 6. Selling and Admin Expenses Budget (show variable expenses and fixed expenses) in an excel

Answer & Explanation Solved by verified expert

See Answer