Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me prepare the master budget for the first quarter of 2023 for each month and the quarter in total. Thank you! Dean's Devices

image text in transcribedimage text in transcribed

Please help me prepare the master budget for the first quarter of 2023 for each month and the quarter in total. Thank you!

Dean's Devices Corporation has the following balance sheet at December 31, 2022: The company is preparing its budget for the first quarter of 2023 and has collected the data below: a. The sales forecast is 2,000;1,700;1,600; and 1,500 units for January, February, March, and April, respectively. The unit sales price is $16. All sales are on credit and collections are 40% in the month of sale and 60% the following month. Accounts receivable is for credit sales only. b. At the end of each month Dean's Devices wants a finished goods inventory equal to 70% of the next month's sales and a direct materials inventory of 120% of that month's production requirement. c. A unit of finished product requires 3 pounds of direct material at $2 a pound, and 30 minutes of direct labor at $7 an hour. Direct materials purchases are paid 25% in the month of purchase and 75% in the following month. Accounts payable is for credit purchases only. All other costs are paid in the month incurred. d. Dean's Devices applies manufacturing overhead to units of product based on direct labour hours. The variable manufacturing overhead rate is $3 per direct labour hour. Fixed manufacturing overhead consists of: salaries $3,000 per month, depreciation $1,500 per month, and other fixed costs $1,110 per month. e. Selling costs are sales commissions (\$0.30 per unit sold) and shipping (\$0.14 per unit sold). Administrative costs each month are: salaries $800; rent $500; and depreciation $400. f. Dean's Devices plans to buy equipment costing $10,000 in January. This will be paid in cash. g. Dean's Devices management requires a minimum cash balance on hand of $10,000. The company can obtain short-term financing at a rate of 8% per year. Borrowings are received at the beginning of the month and repayments are made at the end of the month (both in $1,000 increments). Any interest incurred is paid at the end of the month following the advance

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

Internal Quality Auditing

Authors: Denis Pronovost

1st Edition

0873894766, 9780873894760

More Books

Students also viewed these Accounting questions

Question

why we face Listening Challenges?

Answered: 1 week ago

Question

what is Listening in Context?

Answered: 1 week ago