DXB Electronics has recently approached you as a business consultant to assist them in preparing...

50.1K

Verified Solution

Question

Accounting

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students