Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Introduction To Concepts Methods And Uses

Authors: Sidney Davidson, Roman L. Weil, Clyde P. Stickney

2nd Edition

0030452961, 978-0030452963

More Books

Students also viewed these Accounting questions