Concept explainers
INTEGRATION EXERCISE 9 Master Budgeting LO8-2, LO8-3, LO8-4, LO8-5, LO8-6, LO8-7. LO8-8,LO8-9, LO8-18
Endless Mountain Company manufactures a single product that is popular with outdoor recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a
Endless Mountain Company | ||
Balance Sheet | ||
December 31, 2016 | ||
Assets | ||
Current assets: | ||
Cash | $46,200 | |
Accounts receivable | 260,000 | |
Raw materials inventory (4,500 yards) | 11,250 | |
Finished goods inventory (1,500 units) | 32,250 | |
Total current assets | $349,700 | |
Plant and equipment: | ||
Building and equipment | 900,000 | |
(292,000) | ||
Plant and equipment, net | 608,000 | |
Total Assets | $957,700 | |
Liabilities and |
||
Current liabilities: | ||
Accounts payable | $158,000 | |
Stockholders' equity: | ||
Common stock | $419,800 | |
Retained earnings | 379,900 | |
Total stockholders' equity | 799,700 | |
Total liabilities and stockholders’ equity | $957,700 |
The company’s chief financial officer (CFO), in consultation with various managers across the organization has developed the following set of assumptions to help create the 2017 budget:
- The budgeted unit sales are 12,000 units, 37,000 units15,000 units and 25,000 units for quarters 1—4, respectively.Notice that the company experiences peak sales in the second and fourth quarters. The budgeted selling price for the year is $32 per unit. The budgeted unit sales for the first quarter of 2018is 13,000 units.
- All sales are on credit. Uncollectible accounts arc negligible and can be ignored. Seventy-five percent of all credit sales are collected in the quarter of the sale and 25% are collected in the subsequent quarter.
- Each quarter's ending finished goods inventory should equal 15%of the next quarter's unit sales.
- Each unit of finished goods requires 3.5 yards of raw material that costs $3.00 per yard. Each quarter's ending raw materials inventory should equal l0%of the next quarter's production needs. The estimated ending raw materials inventory on December 31, 2017, is 5.000 yards.
- Seventy percent of each quarter's purchases are paid for in the quarter of purchase. The remaining 30% of each quarter's purchases are paid in the following quarter.
- Direct laborers tare paid $18 an hour and each unit of finished goods requires 0.25 direct labor-hours to complete.All direct labor costs are paid in the quarter incurred.
- The budgeted variable manufacturing overhead per direct labor-hour is $3.00. The quarterly fixed manufacturing overhead is $150,000 including $20.000 of depreciation on equipment. The number of direct labor-hours is used as the allocation base for the budgeted plantwideoverhead rate. All overhead costs (excluding depreciation) are paid in the quarter incurred.
- The budgeted variable selling and administrative expense is $1.25 per unit sold. The fixed selling and administrativeexpenses per quarter include advertising ($25,000), executive salaries ($64,000), insurance ($12,000), property tax ($8,000),and depreciation expense ($8,000). All selling and administrative expenses (excluding depreciation) are paid in the quarter incurred.
- The company plans to maintain a minimum cash balance at the end of each quarter of $30,000. Assume thatany borrowings take place on the first day of the quarter. To the extent possible, the company will repay principal and interest on any borrowings on the last day of the fourth quarter. The company’s lender imposes a simple interest rate of 3% per quarter on any borrowings.
- Dividends of $15,000 will be declared and paid in each quarter.
- The companyuses a last-in, first-out (LIFO) inventoryflow assumption. This means that the most recently purchased raw materials are the “first-out” to production and the most recentlycompleted finished goods are the “first-out” to customers.
Required:
The company’s CFO has asked you to use Microsoft Excel to prepare the 2017 master budget Your Excel file should include a tab that contains the December 31, 2016, balance sheet, a tab that summarizes the budgeting assumptions, and tabs corresponding to the following budget schedules and financial statements:
- Quarterly sales budget including a schedule of expected cash collections.
- Quarterly production budget.
- Quarterly direct materials budget including a schedule of expected cash disbursements for purchases of materials.
- Quarterly direct labor budget.
- Quarterly manufacturing overhead budget.
- Ending finished goods inventory budget at December 31,2017.
- Quarterly selling and administrative expense budget.
- Quarterly
cash budget . - Income statement for the year ended December 31, 2017.
- Balance sheet at December 31, 2017.
Want to see the full answer?
Check out a sample textbook solutionChapter IE Solutions
MANAGERIAL ACCOUNTING
- QUESTION THREE (3) Case Study for Slopes Company. Comprehensive operating budget. Slopes, Inc., manufactures and sells snowboards. Slopes manufactures a single model, the Pipex. In the summer of 2018, Slope's accountant gathered the following data to prepare budgets for 2019: Materials and labor requirements Direct materials: Wood 5 board feet per snowboard Fiberglass 6 yards per snowboard Direct manufacturing labor 5 hours per snowboard Slopes' CEO expects to sell 1,000 snow boards during 2019 at an estimated retail price of RM 450 per board. Further, he expects 2019 beginning inventory of 100 boards, and would like to end 2019 with 200 snowboards in stock. Direct materials inventories Beginning Inventory 1/1/2019 Ending Inventory 12/31/2019 Wood 2,000 1,500 Fiberglass 1,000 2,000 Variable manufacturing overhead is allocated is allocated at the rate RM 7 per direct manufacturing labor-hour. There are also RM 66,000 in fixed manufacturing overhead costs budgeted for 2019.Slopes…arrow_forwardUse the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?arrow_forwardGood night Please answer a,b,c Thanks in advance Makers Ltd. manufactures and sells two products, Abba and Baba. In July 2018 Makers’Budget Department gathered the following data in order to prepare the individual budgets inthe master budget for 2019: 2019 Projected Sales:Product Unit PriceAbba 80,000 $ 190Baba 60,000 $ 270 2019 Inventories in Units: Expected Target:Product January 1, 2019 December 31, 2019Abba 22,000 26,000Baba 9,000 10,000 To produce 1 unit of Abba and Baba, the following direct materials are used:Direct Material Unit Abba BabaA Pounds 5 6B Pounds 3 4C…arrow_forward
- Question 3 a) Why do successful companies tend to use the bottom-up approach to establish a master budget? b) Green Tea's data show the following information for the financial year, beginning July 2020: July Aug. Sept. Oct. Nov. Estimated sales (units) 25,000 25,000 27,000 27,500 28,000 Sales price per unit $31 $31 $31 $31 $31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 $1.50 Labour rate per hour $21 $21 $24 $24 $24 New machinery will be added in September. This machine will reduce the labour required per unit and increase the labour rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next month's requirements. Direct material requires 2.5 kg per unit at a cost of $5 per kg. The ending inventory required for direct materials is 20% of the next month's needs. In July, the beginning inventory is 3,750 units of finished goods and 13,125 kg of materials. Required: i) Prepare a production budget for the first quarter of the…arrow_forwardQ3: Fantastic Cement Manufacturing Company expects from you to calculate and present the master budget for the year 2020 from the following information? 1. Sales budget: Type 1 cement Br400, 000 Type 2 Cement Br600, 000 2. Production costs budget: Direct material cost 70% of sales Direct wages Br 50,000 3. Manufacturing overhead budget : Fixed manufacturing overhead Br 24,000 Variable manufacturing overhead Br 36,000 4. Total Operating expenses budget Br 30,000 Required: prepare a Master Budget for Fantastic Company for Year 2020 and show the expected net profit by considering the above data onlyarrow_forwardQuestion Content Area Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Laghari Company makes and sells high-quality glare filters for microcomputer monitors. John Tanaka, controller, is responsible for preparing Laghari's master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer's share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company's union contract calls for an increase in direct labor wages that is included in the direct labor rate. Laghari expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 35 percent of the following month's projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 36,000 34,500 39,000 38,600 Sales price per unit…arrow_forward
- Management Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.arrow_forwardGood night please answer d,e and question 2 Makers Ltd. manufactures and sells two products, Abba and Baba. In July 2018 Makers’Budget Department gathered the following data in order to prepare the individual budgets inthe master budget for 2019: 2019 Projected Sales:Product Unit PriceAbba 80,000 $ 190Baba 60,000 $ 270 2019 Inventories in Units: Expected Target:Product January 1, 2019 December 31, 2019Abba 22,000 26,000Baba 9,000 10,000 To produce 1 unit of Abba and Baba, the following direct materials are used:Direct Material Unit Abba BabaA Pounds 5 6B Pounds 3 4C…arrow_forward4 Gig Harbor Boating is the wholesale distributor of a small recreational catamaran sailboat. Management has prepared the following summary data to use in its annual budgeting process: Budgeted unit sales. Selling price per unit Cost per unit Variable selling and administrative expense (per unit) Fixed selling and administrative expense (per year) Interest expense for the year Required: Prepare the company's budgeted income statement for the year. Gig Harbor Boating Budgeted Income Statement 500 $ 1,970 $ 1,460 $ 50 $ 196,000 $ 13,000arrow_forward
- c. Cost Control The partners believed that controlling cost is critical to their long term profitability. The following are budgeted and actual activities and cost for the first month of business: SBB SB Budget 1050 Actual Budget Actual Units 990 450 475 3,150 Pattie Bread Toppings Fries Packaging Drinks O/H RM RM 3,100 RM 675 RM 730 RM 525 RM 520 RM 450 RM 490 RM 1,575 RM 720 1,550 800 RM 675 RM RM 840 RM RM 450 RM 455 RM 210 RM 200 RM 90 RM 96 RM 525 RM 500 RM 225 RM 250 RM 4,074 RM 4,014 RM 1,746 RM 1,746 Required: I.Prepare a cost performance report for the first month of operation (Compare actual costs with flexible budgeted costs). II. Discuss the possible causes for significant costs variances (favourable and unfavourable) and recommend correction actions to rectify the costs variances.arrow_forwardGood night please answer d,e and question 2 Makers Ltd. manufactures and sells two products, Abba and Baba. In July 2018 Makers’Budget Department gathered the following data in order to prepare the individual budgets inthe master budget for 2019: 2019 Projected Sales:Product Unit PriceAbba 80,000 $ 190Baba 60,000 $ 270 2019 Inventories in Units: Expected Target:Product January 1, 2019 December 31, 2019Abba 22,000 26,000Baba 9,000 10,000 To produce 1 unit of Abba and Baba, the following direct materials are used:Direct Material Unit Abba BabaA Pounds 5 6B Pounds 3 4C…arrow_forwardQuestion Content Area Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 25 percent of the following month’s projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 35,600 34,600 40,400 39,600 Sales price per…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning