Question & Answer: 8. Cost of goods sold budget ( Assume that there is no change in work in progress inventories)…..

Understanding Relationships, Master Budget, Comprehensive Review

Optima Company is a high-technology organization that produces a mass-storage system. The design of Optima’s system is unique and represents a breakthrough in the industry. The units Optima produces combine positive features of both compact and hard disks. The company is completing its fifth year of operations and is preparing to build its master budget for the coming year (20X1). The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information:

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: 8. Cost of goods sold budget ( Assume that there is no change in work in progress inventories)…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

Fourth-quarter sales for 20X0 are 55,000 units.

Unit sales by quarter (for 20X1) are projected as follows:

First quarter 65,000
Second quarter 70,000
Third quarter 75,000
Fourth quarter 90,000

The selling price is $400 per unit. All sales are credit sales. Optima collects 85% of all sales within the quarter in which they are realized; the other 15% is collected in the following quarter. There are no bad debts.There is no beginning inventory of finished goods. Optima is planning the following ending finished goods inventories for each quarter:

First quarter 13,000 units
Second quarter 15,000 units
Third quarter 20,000 units
Fourth quarter 10,000 units

Each mass-storage unit uses five hours of direct labor and three units of direct materials. Laborers are paid $10 per hour, and one unit of direct materials costs $80.

There are 65,700 units of direct materials in beginning inventory as of January 1, 20X1. At the end of each quarter, Optima plans to have 30% of the direct materials needed for next quarter’s unit sales. Optima will end the year with the same amount of direct materials found in this year’s beginning inventory.

Optima buys direct materials on account. Half of the purchases are paid for in the quarter of acquisition, and the remaining half are paid for in the following quarter. Wages and salaries are paid on the 15th and 30th of each month.

Fixed overhead totals $1 million each quarter. Of this total, $350,000 represents depreciation. All other fixed expenses are paid for in cash in the quarter incurred. The fixed overhead rate is computed by dividing the year’s total fixed overhead by the year’s budgeted production in units.

Variable overhead is budgeted at $6 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred.

Fixed selling and administrative expenses total $250,000 per quarter, including $50,000 depreciation.

Variable selling and administrative expenses are budgeted at $10 per unit sold. All selling and administrative expenses are paid for in the quarter incurred.

The balance sheet as of December 31, 20X0, is as follows:

Assets
Cash $ 250,000
Direct materials inventory 5,256,000
Accounts receivable 3,300,000
Plant and equipment, net 33,500,000
     Total assets $42,306,000
Liabilities and Stockholders’ Equity
Accounts payable $ 7,248,000*
Capital stock 27,000,000
Retained earnings 8,058,000
     Total liabilities and stockholders’ equity $42,306,000
* For purchase of direct materials only.

Optima will pay quarterly dividends of $300,000. At the end of the fourth quarter, $2 million of equipment will be purchased.

Required:

Prepare a master budget for Optima Company for each quarter of 20X1 and for the year in total. The following component budgets must be included:

1. Sales Budget (units and budgeted sales in thousands)

Optima Company
Sales Budget
For the Year Ending December 31, 20X1
Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total
Units
Unit price $ $ $ $ $
Total sales $ $ $ $ $

2. Production budget (amounts in full, not in thousands) If an amount is zero, enter “0”.

Optima Company
Production Budget
For the Year Ending December 31, 20X1
Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total
Sales
Desired ending inventory
Total needs
Less: Beginning inventory
Production

3. Direct Materials Purchases Budget (in thousands, except for per unit/hour data) If required, round answers to one decimal place.

Optima Company
Direct Materials Purchases Budget
For the Year Ending December 31, 20X1
Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total
Production
Materials/unit
Production needs
Desired ending inventory
Total needs
Less: Beginning inventory
Purchases
Cost per unit $ $ $ $ $
Purchase cost $ $ $ $ $

4. Direct Labor Budget (in thousands, except per unit/hour data)

Optima Company
Direct Labor Budget
For the Year Ending December 31, 20X1
Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total
Production
Hours per unit
Hours needed
Cost per hour $ $ $ $ $
Total cost $ $ $ $ $

5. Overhead Budget (in thousands, except per unit/hour data)

Optima Company
Overhead Budget
For the Year Ending December 31, 20X1
Qtr. 1 Qtr. 2 Qtr. 3 Qtr. 4 Total
Budgeted hours
Variable rate $ $ $ $ $
Budgeted VOH $ $ $ $ $
Budgeted FOH
Total OH $ $ $ $ $

6. Selling and Administrative costs

7. Ending finished goods inventory budget

8. Cost of goods sold budget ( Assume that there is no change in work in progress inventories)

9. Cash budget

10. Pro forma Income Statement (using absorption costing)

11. Pro forma Balance Sheet

Expert Answer

 

1 Sale budget budgted unit sales
Qtr. 1 Qtr 2 Qtr 3 Qtr 4 Total
Expected units sales 65,000 70000 75000 90,000 3,00,000
Selling price 400.00 400.00 400.00 400.00 400.00
Total sales 260,00,000 280,00,000 300,00,000 840,00,000 1200,00,000
2 Production budget Qtr. 1 Qtr 2 Qtr 3 Qtr 4 Total
Budgeted sales 65,000 70000 75000 90000 3,00,000
Add Ending inventory 13000 15000 20000 10000 10000
Required units of available production 78,000 85,000 95,000 1,00,000 3,10,000
Less beginning inventory 0 13,000 15000 20000 0
Units to be produced 78,000 72,000 80,000 80000 3,10,000
3 Direct material budget Qtr. 1 Qtr 2 Qtr 3 Qtr 4 Total
Number of units produced 78,000 72,000 80,000 80,000 3,10,000
Basis of units 3 3 3 3 3
Production needs 2,34,000 2,16,000 2,40,000 2,40,000 9,30,000
Add ending material inventory 30% 64800 72000 72000 65700 65700
Total material requirements 298800 288000 312000 305700 9,95,700
Less beginning material inventory 65700 64800 72000 72000 65700
Material to be purchased 233100 223200 240000 233700 9,30,000
Material price per unit 80 80 80 80 80
Total cost of direct material purchases 18648000 17856000 19200000 18696000 744,00,000
4 direct labor budget Qtr. 1 Qtr 2 Qtr 3 Qtr 4 Total
Production budget units 78,000 72,000 80,000 80,000 3,10,000
Per unit direct hours required 5 5 5 5 5
Total labor hours needed 390000 360000 400000 400000 1550000
Labor price per hour 10 10 10 10 10
Labor dollars 3900000 3600000 4000000 4000000 15500000

Grand Paper Writers
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

All papers are written by the best professional writers to ensure 100% originality. We always provide plagiarism reports whenever we deliver completed papers.

Free Revisions

All papers by Grand Paper Writers are completed and submitted on time. This timely delivery of papers gives you time to go through the paper before the official deadline.

Title-page

As an additional service, we will provide a title page that precedes the contents of your paper. Here, you will provide your personal details.

Bibliography

We also ensure that we provide an extra page for the references or bibliographies following referencing rules.

Originality & Security

At Grandpaperwriters.com, we guarantee students for the provision of security and original work. All your personal information is handled with confidentiality and is not shared with third parties. Additionally, we ensure that we provide original content with accompanying plagiarism reports to show originality.

24/7 Customer Support

Our customer support team is always available 24/7 to provide instant responses to any queries raised by students.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Grandpaperwriters.com has the best professional essay writers for quality services.

Pricing

Flexible Pricing

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Communication

Admission Help & Client-Writer Contact

Grandpaperwriters.com provides an interactive portal where students can communicate directly to their writers.

Deadlines

Paper Submission

Here, a Grandpaperwriters.com, we do not compromise on the time of our clients. We always deliver all completed papers on or before the deadlines.

Reviews

Customer Feedback

Grandpaperwriters.com appreciates feedback from our clients to help us improve the delivery of essay writing services. As such, we are constantly changing our policies to ensure maximum customer and writer satisfaction.