HORNGREN COST ACCT NON-MAJORS W/ACCESS
17th Edition
ISBN: 9781323703748
Author: Datar
Publisher: Pearson Custom Publishing
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 6, Problem 6.26E
Revenues and production budget. Saphire, Inc., bottles and distributes mineral water from the company’s natural springs in northern Oregon. Saphire markets two products: 12-ounce disposable plastic bottles and 1-gallon reusable plastic containers.
- 1. For 2018, Saphire marketing managers project monthly sales of 500,000 12-ounce bottles and 130,000 1-gallon containers. Average selling prices are estimated at $0.30 per 12-ounce bottle and $1.60 per 1-gallon container. Prepare a revenues budget for Saphire, Inc., for the year ending December 31, 2018.
Required
- 2. Saphire begins 2018 with 980,000 12-ounce bottles in inventory. The vice president of operations requests that 12-ounce bottles ending inventory on December 31, 2018, be no less than 660,000 bottles. Based on sales projections as budgeted previously, what is the minimum number of 12-ounce bottles Saphire must produce during 2018?
- 3. The VP of operations requests that ending inventory of 1-gallon containers on December 31, 2018, be 300,000 units. If the production budget calls for Saphire to produce 1,200,000 1-gallon containers during 2018, what is the beginning inventory of 1-gallon containers on January 1, 2018?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Saphire, Inc., bottles and distributes mineral water from the company’s natural springs in northern Oregon. Saphire markets two products: 12-ounce disposable plastic bottles and 1-gallon reusable plastic containers.
Q1. For 2018, Saphire marketing managers project monthly sales of 500,000 12-ounce bottles and 130,000 1-gallon containers. Average selling prices are estimated at $0.30 per 12-ounce bottle and $1.60 per 1-gallon container. Prepare a revenues budget for Saphire, Inc., for the year ending December 31, 2018.
Stone Canyon Muffins sells its muffins to restaurants and coffee houses for an average selling price of $27 per case. The following information relates to the budget for Stone Canyon Muffins for this year (all figures are annual totals unless otherwise noted):
Budget information:
Budgeted sales in cases. . . . . .
9,300 cases
Packaging cost per case. . . . . .
$4
Shipping expense per case. . . .
$2
Sales commission expense. . . .
1% of sales price
Salaries expense. . . . . . . . . . . .
$7,000
Office rent. . . . . . . . . . . . . . . . .
$3,800
Depreciation. . . . . . . . . . . . . . .
$2,600
Insurance expense. . . . . . . . . .
$2,500
Office supplies expense. . . . . .
$600
Actual expenses:
Packaging cost. . . . . . . . . . . . . .
$39,300
Shipping expense. . . . . . . . . . . .
$21,800
Sales commission expense. . . . .
$2,641
Salaries expense. . . . . . . . . . . . .
$8,500
Office rent.…
Springton makes and sells a single product, black handbags, at a price of $1,600 each. During the three months to December 31,2020, he sold 1,500 handbags and turnover was the same for each month.
He expects the volume of sales to remain unchanged for January 2021 but to increase by 5% in February, and by a further 20% in April. The price of the handbags will be increased by 10% in January and by a further 5% in June.
The following budgeted information is presented to assist in the preparation.
Month
Budgeted sales
$
Budgeted purchases
$
January
880,000
600,000
February
924,000
750,000
March
924,000
820,000
April
1,108,800
820,000
May
1,250,000
968,000
June
1,285,000
1,250,000
Notes:
Effective January 1, 2021 Springton’s collection on sales will be as follows:
70% collected in the month of sale
The balance will be collected one month following sale
Required:
Prepare a sales budget for the handbags…
Chapter 6 Solutions
HORNGREN COST ACCT NON-MAJORS W/ACCESS
Ch. 6 - What are the four elements of the budgeting cycle?Ch. 6 - Define master budget.Ch. 6 - Strategy, plans, and budgets are unrelated to ore...Ch. 6 - Budgeted performance is a better criterion than...Ch. 6 - Production managers and marketing managers are...Ch. 6 - Budgets meet the cost-benefit test. They force...Ch. 6 - Define rolling budget. Give an example.Ch. 6 - Outline the steps in preparing an operating...Ch. 6 - The sales forecast is the cornerstone for...Ch. 6 - Prob. 6.10Q
Ch. 6 - Define Kaizen budgeting.Ch. 6 - Prob. 6.12QCh. 6 - Explain how the choice of the type of...Ch. 6 - What are some additional considerations that arise...Ch. 6 - Prob. 6.15QCh. 6 - Master budget. Which of the following statements...Ch. 6 - Operating and financial budgets. Which of the...Ch. 6 - Production budget. Superior Industries sales...Ch. 6 - Responsibility centers. Elmhurst Corporation is...Ch. 6 - Cash budget. Mary Jacobs, the controller of the...Ch. 6 - Sales budget, service setting. In 2017 Hart Sons,...Ch. 6 - Sales and production budget. The Coby Company...Ch. 6 - Direct material budget. Dawson Co. produces wine....Ch. 6 - Material purchases budget. The McGrath Company has...Ch. 6 - Revenues, production, and purchases budgets. The...Ch. 6 - Revenues and production budget. Saphire, Inc.,...Ch. 6 - Budgeting; direct material usage, manufacturing...Ch. 6 - Budgeting, service company. Ever Clean Company...Ch. 6 - Budgets for production and direct manufacturing...Ch. 6 - Activity-based budgeting. The Jerico store of...Ch. 6 - Kaizen approach to activity-based budgeting...Ch. 6 - Responsibility and controllability. Consider each...Ch. 6 - Responsibility, controllability, and stretch...Ch. 6 - Cash flow analysis, sensitivity analysis....Ch. 6 - Budget schedules for a manufacturer. Hale...Ch. 6 - Budgeted costs, Kaizen improvements environmental...Ch. 6 - Revenue and production budgets. (CPA, adapted) The...Ch. 6 - Budgeted income statement. (CMA, adapted) Smart...Ch. 6 - Prob. 6.39PCh. 6 - Comprehensive problem with ABC costing. Animal...Ch. 6 - Cash budget (continuation of 6-40). Refer to the...Ch. 6 - Comprehensive operating budget. Skulas, Inc.,...Ch. 6 - Cash budgeting, budgeted balance sheet....Ch. 6 - Comprehensive problem; ABC manufacturing, two...Ch. 6 - Cash budget. (Continuation of 6-44) (Appendix)...Ch. 6 - Budgeting and ethics. Jayzee Company manufactures...Ch. 6 - Kaizen budgeting for carbon emissions. Apex...Ch. 6 - Comprehensive budgeting problem; activity-based...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.arrow_forwardNovo, Inc., wants to develop an activity flexible budget for the activity of moving materials. Novo uses eight forklifts to move materials from receiving to stores. The forklifts are also used to move materials from stores to the production area. The forklifts are obtained through an operating lease that costs 18,000 per year per forklift. Novo employs 25 forklift operators who receive an average salary of 50,000 per year, including benefits. Each move requires the use of a crate. The crates are used to store the parts and are emptied only when used in production. Crates are disposed of after one cycle (two moves), where a cycle is defined as a move from receiving to stores to production. Each crate costs 1.80. Fuel for a forklift costs 3.60 per gallon. A gallon of gas is used every 20 moves. Forklifts can make three moves per hour and are available for 280 days per year, 24 hours per day (the remaining time is downtime for various reasons). Each operator works 40 hours per week and 50 weeks per year. Required: 1. Prepare a flexible budget for the activity of moving materials, using the number of cycles as the activity driver. 2. Calculate the activity capacity for moving materials. Suppose Novo works at 80 percent of activity capacity and incurs the following costs: Prepare the budget for the 80 percent level and then prepare a performance report for the moving materials activity. 3. Calculate and interpret the volume variance for moving materials. 4. Suppose that a redesign of the plant layout reduces the demand for moving materials to one-third of the original capacity. What would be the budget formula for this new activity level? What is the budgeted cost for this new activity level? Has activity performance improved? How does this activity performance evaluation differ from that described in Requirement 2? Explain.arrow_forwardPlay-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forward
- Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?arrow_forwardCoral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?arrow_forwardPilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forward
- Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.arrow_forwardNozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.arrow_forwardCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forward
- Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.arrow_forwardOperating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.arrow_forwardCloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY