Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 2018 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. c. The selling price is $50 per unit. Sales are estimated to be collected 70% in cash and 30% credit. d. Of the credit sales, 80% are estimated to be collected in the quarter of the sale and the remaining 20% is collected in the quarter following the sale. e. Okay's past experience indicates that cost of goods sold is about 60 percent of sales. f. Since this is the first year of operations there is no beginning inventory at the beginning of the year. Okay's ending inventory policy is 40% of the following quarter's inventory needs. Desired ending inventory for 4th Qtr is $74,000. g. Okay buys inventory on account. The purchases are paid for in full the quarter following the purchase. h. Selling and administrative expenses total $15,000 per quarter, which includes $2,500 depreciation. All selling and administrative expenses requiring cash payments are paid for in the month incurred. Required: Prepare the following budgets for Okay Company for all 4 quarters and yearly total: 1. Sales budget 2. Sales Type 3. Cash Collections of Sales 4. Inventory purchases budget 5. Cash Payments of Inventory 6. Selling and Administrative expenses budget 7. Cash Payments of Selling and Administrative expenses 8. Cash budget Requirement #1 Unit sales X Selling Price Total Sales Revenue Requirement #2 Cash sales Credit Sales Total Sales Revenue Sales Budget Quarter 1 Quarter 2 Quarter 3 Type of Sale Quarter 1 Quarter 2 Quarter 3 Requirement #3 Cash Collections from Sales to be used in the Cas Quarter 1 Quarter 2 Quarter 3 Cash Collections from Cash Sales Cash Collections from 1st Qtr Credit Sales Cash Collections from 2nd Qtr Credit Sales Cash Collections from 3rd Qtr Credit Sales Cash Collections from 4th Qtr Credit Sales Total Cash Collections from Sales Requirement #4 Quarter 1 Inventory Purchases Budget Quarter 2 Quarter 3 Total Sales Revenue X CGS % CGS Plus: Desired ending inventory Less: Beginning inventory TOTAL Quantity of Inventory to purchase Requirement #5 Cash Payments for Inventory Purchases to be used in t Total Cash Payments for DM Purchases Quarter 1 Requirement #6 Quarter 1 Total S&A exp. Budget Requirement #7 Quarter 2 Quarter 3 Selling and Administrative Expense Budg Quarter 2 Quarter 3 Cash payments of Selling and Administrative Expenses to be u Total S&A exp. Less: Op. Exp. Deprec. (non-cash item) Total Op. Exp. paid for in Cash Requirement #8 Beg. Cash Plus: Collections from Sales Less: Inventory Payments Less: Payments for S&A Expenses Ending Cash Quarter 1 Quarter 2 Quarter 3 Cash Budget Quarter 1 Quarter 2 Quarter 3 $ Quarter 4 Total Quarter 4 Total h Budget Quarter 4 Total $ Quarter 4 Total 74,000.00 $ 74,000.00 he Cash Budget $ Quarter 4 Total et Quarter 4 Total sed in the Cash Budget Quarter 4 Total Quarter 4 Total 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 2018 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. c. The selling price is $50 per unit. Sales are estimated to be collected 70% in cash and 30% credit. d. Of the credit sales, 80% are estimated to be collected in the quarter of the sale and the remaining 20% is collected in the quarter following the sale. e. Okay's past experience indicates that cost of goods sold is about 60 percent of sales. f. Since this is the first year of operations there is no beginning inventory at the beginning of the year. Okay's ending inventory policy is 40% of the following quarter's inventory needs. Desired ending inventory for 4th Qtr is $74,000. g. Okay buys inventory on account. The purchases are paid for in full the quarter following the purchase. h. Selling and administrative expenses total $15,000 per quarter, which includes $2,500 depreciation. All selling and administrative expenses requiring cash payments are paid for in the month incurred. Required: Prepare the following budgets for Okay Company for all 4 quarters and yearly total: 1. Sales budget 2. Sales Type 3. Cash Collections of Sales 4. Inventory purchases budget 5. Cash Payments of Inventory 6. Selling and Administrative expenses budget 7. Cash Payments of Selling and Administrative expenses 8. Cash budget Requirement #1 Unit sales X Selling Price Total Sales Revenue Requirement #2 Cash sales Credit Sales Total Sales Revenue Sales Budget Quarter 1 Quarter 2 Quarter 3 Type of Sale Quarter 1 Quarter 2 Quarter 3 Requirement #3 Cash Collections from Sales to be used in the Cas Quarter 1 Quarter 2 Quarter 3 Cash Collections from Cash Sales Cash Collections from 1st Qtr Credit Sales Cash Collections from 2nd Qtr Credit Sales Cash Collections from 3rd Qtr Credit Sales Cash Collections from 4th Qtr Credit Sales Total Cash Collections from Sales Requirement #4 Quarter 1 Inventory Purchases Budget Quarter 2 Quarter 3 Total Sales Revenue X CGS % CGS Plus: Desired ending inventory Less: Beginning inventory TOTAL Quantity of Inventory to purchase Requirement #5 Cash Payments for Inventory Purchases to be used in t Total Cash Payments for DM Purchases Quarter 1 Requirement #6 Quarter 1 Total S&A exp. Budget Requirement #7 Quarter 2 Quarter 3 Selling and Administrative Expense Budg Quarter 2 Quarter 3 Cash payments of Selling and Administrative Expenses to be u Total S&A exp. Less: Op. Exp. Deprec. (non-cash item) Total Op. Exp. paid for in Cash Requirement #8 Beg. Cash Plus: Collections from Sales Less: Inventory Payments Less: Payments for S&A Expenses Ending Cash Quarter 1 Quarter 2 Quarter 3 Cash Budget Quarter 1 Quarter 2 Quarter 3 $ Quarter 4 Total Quarter 4 Total h Budget Quarter 4 Total $ Quarter 4 Total 74,000.00 $ 74,000.00 he Cash Budget $ Quarter 4 Total et Quarter 4 Total sed in the Cash Budget Quarter 4 Total Quarter 4 Total
Expert Answer:
Related Book For
Cornerstones of Managerial Accounting
ISBN: 978-0176530884
2nd Canadian edition
Authors: Maryanne M. Mowen, Don Hanson, Dan L. Heitger, David McConomy, Jeffrey Pittman
Posted Date:
Students also viewed these finance questions
-
Is there an easily identifiable debt/equity ratio that maximizes a company's market value? Why or why not?
-
Quaint Stem Company is a high-end glassware manufacturer that produces fine stemware of the highest quality. The company is completing its fourth year of operations and is preparing to build its...
-
Optima Company is a high-technology organization that produces a mass-storage system. The design of Optimas system is unique and represents a breakthrough in the industry. The units Optima produces...
-
Santa's Helpers Ltd estimates its income taxes at 35% of pre-tax income. For the quarter ended September 30, pre-tax income was $200,000. Prepare the journal entry to record the estimated income...
-
Paul, a bookkeeper employed by Harveys Car Lot, forged Harveys signature on a number of cheques over the course of a year. The cheques were made payable to fictitious payees. Paul deposited the...
-
Predation by one flour beetle species on another can be used as a potent means of interference competition. However, the predatory strategy seems to fail consistently in the presence of the protozoan...
-
Describe briefly what economists call a multitask agency problem, and relate your answer to the case of microfinance. Describe the main tasks taken on by loan officers and how they might conflict or...
-
Orasco Company uses both standards and budgets. For the year, estimated production of Product X is 500,000 units. Total estimated cost for materials and labor are $1,200,000 and $1,600,000. Compute...
-
Required information [The following information applies to the questions displayed below.] Alanis Morgan owns White Mountain Assessments in Laconia, New Hampshire. The standard workweek is 40 hours....
-
What is a sales return?Multiple choice question.A sales return is the cash discount given for early payment of an invoice.A sales return refers to merchandise a seller acquires, but then returns to...
-
Calculate the following for the given frequency distribution: Data Frequency 60 63 10 64 67 23 68 71 14 72 75 8 76 79 4 80 83 5 Population Mean Population Standard Deviation Round to two decimal...
-
What are the roles that can be taken by intermediaries in supply chain management? How does supply chain management help to create value? How are the concepts of push and pull different when it comes...
-
A vibration isolation unit consists of two blocks of hard rubber bonded to plate AB and to rigid supports as shown. For the type and grade of rubber used, the allowable shear stress is 5.5% *SN (MPa)...
-
compute the slope of the tangent line to 2(x + y2)2 - 25(x2 y2) = 0 at (3, 1), with a precision of two digits after the decimal point (meaning that you should correctly identify all digits left of...
-
What is the best option contraceptives for minors age 14-17 years old. Popetentiate with uptodate resounces and citations?
-
In the twovideos you were introduced to the concept of CPI or Continuous Process Improvements. You have learned that the Value Chain is comprised of multiple processes that create value for the...
-
The Ferris wheel in the figure has a radius of 68 feet. The clearance between the wheel and the ground is 14 feet. The rectangular coordinate system shown has its origin on the ground directly below...
-
What is the necessary condition for a share buyback to increase earnings per share? to increase the book value of equity capital per share?
-
In what circumstances does a company have good reason to have a capital decrease?
-
Forgetting tax considerations, can a capital decrease enhance the value of the companys operating assets? the value of its shares?
Study smarter with the SolutionInn App