Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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:
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started