Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If you could include calculations that would be extremely helpful! Thank you. Oak Creek Company is preparing its master budget for 2020. Relevant data pertaining

If you could include calculations that would be extremely helpful! Thank you.

image text in transcribedimage text in transcribedimage text in transcribed

Oak Creek Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales: Sales for the year are expected to total 1,000,000 units. Quarterly sales are 20%, 25%, 25%, and 30%, respectively. The sales price is expected to be $40 per unit for the first three quarters and $46 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 10% higher than the budgeted sales for the first quarter of 2020. Production: Management desires to maintain the ending finished goods inventories at 20% of the next quarter's budgeted sales volume. Direct materials: Each unit requires 2 kg of raw materials at a cost of $10 per kilogram. Management desires to maintain raw materials inventories at 10% of the next quarter's production requirements. Assume the production requirements for the first quarter of 2021 are 600,000 kg. v (al) Your answer is correct. Prepare the sales budget by quarters for 2020. OAK CREEK COMPANY Sales Budget For the Year Ending December 31, 2020 Quarter 2 3 1 4 Year 200000 Unit sales 250000 250000 300000 1000000 40 40 40 46 Unit price 8,000,000 10,000,000 10,000,000 Total sales 13,800,000 41,800,000 Prepare the production budget by quarters for 2020. OAK CREEK COMPANY Production Budget For the Year Ending December 31, 2020 Quarter 1 2. 3 Year 4 Unit sales 200000 250000 250000 300000 1,000,000 Add Ending inventory 50000 50000 60000 44000 Total required 250000 300000 310000 344000 X Less Beginning inventory v 40000 50000 50000 60000 0 210000 250000 260000 284000 1,004,000 Total Prepare the direct materials budget by quarters for 2020. OAK CREEK COMPANY Direct Materials Budget For the Year Ending December 31, 2020 Quarter 1 2 3 4 Year Units to be produced 210000 250000 260000 284000 1,004,000 > > Direct materials per unit 2 2 2 8 Total kilograms required for production 420000 500000 520000 568000 2,008,000 X x Add Desired ending inventory 50000 52000 56800 63000 221,800 X Total materials required 470,000 552,000 576,800 631,000 2,229,800 X Less Beginning materials inventory 42000 50000 52000 56800 200,800 x X X Direct materials per unit 428000 502000 524800 574200 2,029,000 X 10 10 10 10 40 Cost per kilogram $1 4,280,000 5,020,000 Total cost of direct materials purchases 5,248,000 5,742,000 20,290,000 $ $ HA

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

Step: 3

blur-text-image

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

Research Methods And Audit In General Practice

Authors: David Armstrong, John Grace

1st Edition

0192624547, 978-0192624543

More Books

Students also viewed these Accounting questions