Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Please prepare a production budget with the following master budget information: Projected unit sales for each quarter for 2013 are as follows: Quarter 1 60,000

Please prepare a production budget with the following master budget information:

  1. Projected unit sales for each quarter for 2013 are as follows:

Quarter 1 60,000

Quarter 2 70,000

Quarter 3 80,000

Quarter 4 65,000

  1. The selling price is $500 per unit. All sales are on credit (no cash sales). 70% of all sales are collected within the quarter they are sold. The other 30% are collected in the following quarter. There are no bad debts.
  2. There is no beginning inventory of finished goods. The projected ending finished goods inventories are as follows:

Quarter 1 15,000 units

Quarter 2 20,000 units

Quarter 3 10,000 units

Quarter 4 5,000 units

  1. There are no beginning or ending inventories of work-in-process.
  2. Each unit produced uses 10 hours of direct labor. Laborers are paid $15 per hour.
  3. Each unit produced uses 5 units of direct materials. One unit of direct materials costs $50.
  4. There are 100,000 units of direct materials in beginning inventory as of January 1, 2013. There is estimated to be 70,000 units of direct materials in beginning inventory as of January 1, 2014 (what is ending inventory December 31, 2013?). At the end of each quarter, the desired ending inventory is 30% of the direct materials needed for production for the next quarter.
  5. Direct materials are purchased on account. 60% are paid for in the quarter of purchase, and the remaining 40% are paid for in the next quarter.
  6. Fixed overhead totals $500,000 each quarter. Of this total, $100,000 is depreciation. The remaining $400,000 is paid for in cash in the quarter incurred. The fixed overhead rate for the Finished Goods inventory budget is calculated by dividing the years total fixed overhead by the years budgeted production in units.
  7. Variable overhead is budgeted at $5 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred.
  8. Fixed selling and administrative expenses total $200,000 per quarter, including $50,000 depreciation.
  9. Variable selling and administrative expenses are budgeted at $10 per unit sold. All selling and administrative expenses are paid for in the quarter incurred.
  10. The balance sheet as of December 31, 2012 is

Assets:

Cash $300,000,000

Direct Materials Inventory $5,000,000

Accounts Receivable $0

Plant & Equip, net $20,000,000

Total Assets $325,000,000

Liabilities & Stockholders Equity:

Accounting Payable $0

Capital Stock $175,000,000

Retained Earnings $150,000,000

Total Liab & Stckhldrs Equity $325,000,000

  1. Quarterly dividends of $100,000 will be paid.
  2. At the end of Quarter 4, 2013, equipment costing $500,000 will be purchased.

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

The Classification And Coding Of Accounting Information

Authors: R. Fox

2nd Edition

0948036885, 978-0948036880

More Books

Students also viewed these Accounting questions

Question

How can you encourage creative problem solving by others?

Answered: 1 week ago

Question

Differentiate 3sin(9x+2x)

Answered: 1 week ago

Question

LO6 Describe how individual pay rates are set.

Answered: 1 week ago