Master Budget Project
Okay Company is preparing to build its master budget. 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. This will be the first year of operation for Okay Company.
b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300 , Second quarter 6,100 , Third quarter 6,100 & Fourth quarter 6,450 . First and second quarter 2018 budgeted sales units is 6,400 each quarter.
c. The selling price is $ 45 per unit. Sales are estimated to be collected 75 % in cash and 25 % credit. Of the credit sales, 85 % are estimated to be collected in the quarter following the sale and 15 % are collected in the second quarter following the sale.
d. Since this is the first year of operations there is no beginning inventory of finished goods at the beginning of the year. Okay's ending finished good inventory policy is 35 % of the following quarter's unit sales needs.
e. Each unit uses 0.50 hours of direct labor and 2 units of direct materials. Laborers are paid $ 12 per hour and one unit of direct materials costs $ 4.50.
f. Since this is the first year of operations there is no beginning inventory of direct materials at the beginning of the year. Okay plans to have 30 % of the direct materials needed for the next quarter's production units on hand at the end of each quarter.
g. Okay buys direct materials on account. 80 % of the purchases are paid for in the quarter of acquisition, and the remaining 20 % are paid for in the following quarter.
h. Fixed overhead totals $ 25,000 each quarter. Of this total, $ 5,000 represents depreciation. All other fixed expenses are paid for in cash in the quarter incurred.
i. Variable overhead is budgeted at $ 3 per units produced. All variable overhead expenses are paid for in the quarter incurred.
j. Fixed selling and administrative expenses total $ 15,000 per quarter, including $ 2,500 depreciation.
k. Variable selling and administrative expenses are budgeted at $ 1.25 per unit sold. All selling and administrative expenses are paid for in the quarter incurred.
1. Okay will pay quarterly dividends of $ 10,000. During the fourth quarter, $ 135,000 of equipment will be purchased.
Required: Prepare a master budget for Okay Company for each quarter of 2017 and for the year in total. The following component budgets must be included:
1. Sales budget
2. Cash Collections of Sales
3. Production budget
4. Direct materials purchases budget
5. Cash Payments of Direct materials
6. Direct labor budget
7. Overhead budget
8. Operating expenses budget
9. Cash budget
I am uploading snapshots as entire excel table was not coming due to character limit.
All the 9 parts have been solved
Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total.
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...
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...
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...
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...
Having issues with 6,7,and 8 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...
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 Quarter 2 70,000 Quarter 3 80,000 Quarter 4 65,000 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. There is no beginning inventory...
Having a hard time with #6 - 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...
9. If more information is required please be specific in what is needed. 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...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...
Optima Company is a high-technology organisation 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 (2017). The budget will detail each quarter's activity and the activity for the year in total. The master budget will be...