GIVEN DATA:
Fourth-quarter sales for 2016 = 65 000 units.
First quarter = 75 000
Second quarter = 80 000
Third quarter = 85 000
Fourth quarter = 95 000
Selling price = $500 per unit
Optima collects = 85% of all sales
other collected = 15%
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
Direct materials costs = $80.
Direct materials in beginning inventory = 65700 units
And some additional information & balance sheet details as shown in the above information ect...
REQUIRTED:
1. Sales budget
2. Production budget
3. Direct materials purchases budget
4. Direct labor budget
5. Overhead budget
6. Selling and administrative expenses budget
7. Ending finished goods inventory budget
8. Cost of goods sold budget (Assume that there is no change in work-in-process
inventories.)
9. Cash budget
10. Pro forma income statement (using absorption costing)
11. Pro forma balance sheet
Expert Answer
SOLUTION:
1. OPTIMA COMPANY SALES BUDGET :
WORKING NOTE:
unit sold * sale price = Total sales
Q1 : 75000 *500 = 37500000$
Q2 : 80000 * 500 = 40000000$
Q3 :85000 * 500 = 42500000$
Q4: 95000 * 500 = 47500000$
There fore total sales budget is 167500000$
2. OPTIMA COMPANY PRODUCTION BUDGET:
WORKING NOTE:
PRODUCTION UNITS : sales units + closing inventory = total requiredment - opening stock.
Q1 : 75000 +13000 = 88000 - NIL
= 88000
remaining Q2, Q3, Q4 Also calculate like that only
There fore total Production budget is 345000$
3. OPTIMA COMPANY DIRECT MATERIALS PURCHASE BUDGET:
4.OPTIMA COMPANY DIRECT LOBOR BUDGET:
Note : I have subject knowledge for above questions due to insufficent time ican't answer remaining questions please, post as another question
Optima Company is a high-technology organisation that produces a mass-storage system. The design of Optima's system...
01. 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...
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...
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...
Problem 9-73 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...
02. 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...
11. 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...
having issues with 9,10,11 Problem 9-73 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...
SelfKlin Company is a high-technology organisation that produces Robotic Vacuum. The company is completing its tenth year of operations and is preparing to build its master budget for the coming year (2019). 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: a Fourth-quarter sales for 2018 are 65 000 units. b Unit sales by quarter (for 2019) are projected as follows: First quarter 65...
SelfKlin Company is a high-technology organisation that produces Robotic Vacuum. The company is completing its tenth year of operations and is preparing to build its master budget for the coming year (2019). 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: a Fourth-quarter sales for 2018 are 65 000 units. b Unit sales by quarter (for 2019) are projected as follows: First quarter 65...
Having issues with 9,10,11 Problem 9-73 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...