Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 50E
Use 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?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Berring Company produces two products: the deluxe and the standard. The deluxe sells for $40,and the standard sells for $10. Projected sales of the two models for the coming four quartersare given below.
Deluxe StandardFirst quarter 12,000 90,000Second quarter 14,300 88,400Third quarter 16,600 92,000Fourth quarter 20,000 91,600
The president of the company believes that the projected sales are realistic and can beachieved by the company. In the factory, the production supervisor has received the projectedsales figures and gathered information needed to compile production budgets. He found that1,300 deluxes and 1,170 standards were in inventory on January 1. Company policy dictates thatending inventory should equal 20 percent of the next quarter’s sales for deluxes and 10 percentof next quarter’s sales for standards.Required:1. Prepare a sales budget for each quarter and for the year in total. Show sales by product andin total for each time period.2. What factors might Berring Company…
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 five quarters are as follows: Line Item Description S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 20Y2 900 1,200 The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Required: Question Content Area 1. Prepare a sales budget for each quarter of 20Y1 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer. Stillwater Designs Sales Budget For the Year Ended December 31, 20Y1 Line Item Description 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year S12L7: Units Units Units Units Units Units Price $Price $Price $Price $Price $Price Sales $Sales $Sales $Sales…
Woodland Wearables produces two models of a smart watch, the Basic and the Flash. The watches have the following characteristics:
Basic
Flash
Selling price per watch
$ 450
$ 550
Variable cost per watch
$ 370
$ 310
Expected sales (watches) per year
75,000
25,000
The total fixed costs per year for the company are $1,632,000.
Required:
What is the anticipated level of profits for the expected sales volumes?
Assuming that the product mix is the same at the break-even point, compute the break-even point in units.
If the product sales mix were to change to nine Basic watches for each Flash watch, what would be the new break-even volume for Woodland Wearables?
Chapter 9 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
Ch. 9 - Define the term budget. How are budgets used in...Ch. 9 - Prob. 2DQCh. 9 - Explain how both small and large organizations can...Ch. 9 - Prob. 4DQCh. 9 - What is a master budget? An operating budget? A...Ch. 9 - Explain the role of a sales forecast in budgeting....Ch. 9 - All budgets depend on the sales budget. Is this...Ch. 9 - Why is goal congruence important?Ch. 9 - Why is it important for a manager to receive...Ch. 9 - What is participative budgeting? Discuss some of...
Ch. 9 - A budget too easily achieved will lead to...Ch. 9 - Explain why a manager has an incentive to build...Ch. 9 - Discuss the differences between static and...Ch. 9 - Explain why mixed costs must be broken down into...Ch. 9 - What is the purpose of a before-the-fact flexible...Ch. 9 - Prob. 1MCQCh. 9 - Which of the following is part of the control...Ch. 9 - Which of the following is not an advantage of...Ch. 9 - The budget committee a. reviews the budget. b....Ch. 9 - A moving, 12-month budget that is updated monthly...Ch. 9 - Which of the following is not part of the...Ch. 9 - Before a direct materials purchases budget can be...Ch. 9 - The first step in preparing the sales budget is to...Ch. 9 - Which of the following is needed to prepare the...Ch. 9 - A company requires 100 pounds of plastic to meet...Ch. 9 - A company plans to sell 220 units. The selling...Ch. 9 - Select the one budget below that is not an...Ch. 9 - A company has the following collection pattern:...Ch. 9 - The percentage of accounts receivable that is...Ch. 9 - Which of the following is not an advantage of...Ch. 9 - Prob. 16MCQCh. 9 - For performance reporting, it is best to compare...Ch. 9 - To create a meaningful performance report, actual...Ch. 9 - To help assess performance, managers should use a...Ch. 9 - A firm comparing the actual variable costs of...Ch. 9 - Preparing a Sales Budget Patrick Inc. sells...Ch. 9 - Preparing a Production Budget Patrick Inc. makes...Ch. 9 - Preparing a Direct Materials Purchases Budget...Ch. 9 - Preparing a Direct Labor Budget Patrick Inc. makes...Ch. 9 - Preparing an Overhead Budget Patrick Inc. makes...Ch. 9 - Preparing an Ending Finished Goods Inventory...Ch. 9 - Preparing a Cost of Goods Sold Budget Andrews...Ch. 9 - Preparing a Selling and Administrative Expenses...Ch. 9 - Preparing a Budgeted Income Statement Oliver...Ch. 9 - Preparing a Schedule of Cash Collections on...Ch. 9 - Preparing an Accounts Payable Schedule Wight Inc....Ch. 9 - Preparing a Cash Budget La Famiglia Pizzeria...Ch. 9 - Flexible Budget with Different Levels of...Ch. 9 - Performance Report Based on Budgeted and Actual...Ch. 9 - Preparing a Sales Budget Tulum Inc. sells powdered...Ch. 9 - Preparing a Production Budget Tulum Inc. makes a...Ch. 9 - Preparing a Direct Materials Purchases Budget...Ch. 9 - Preparing a Direct Labor Budget Tulum Inc. makes a...Ch. 9 - Preparing an Overhead Budget Tulum Inc. makes a...Ch. 9 - Prob. 40BEBCh. 9 - Preparing a Cost of Goods Sold Budget Lazlo...Ch. 9 - Preparing a Selling and Administrative Expenses...Ch. 9 - Preparing a Budgeted Income Statement Jameson...Ch. 9 - Preparing a Schedule of Cash Collections on...Ch. 9 - Pilsner Inc. purchases raw materials on account...Ch. 9 - Preparing a Cash Budget Olivers Bistro provided...Ch. 9 - Flexible Budget with Different Levels of...Ch. 9 - Performance Report Based on Budgeted and Actual...Ch. 9 - Planning and Control a. Dr. Jones, a dentist,...Ch. 9 - Use the following information for Exercises 9-50...Ch. 9 - Prob. 51ECh. 9 - Production Budget and Direct Materials Purchases...Ch. 9 - Production Budget Aqua-Pro Inc. produces...Ch. 9 - Direct Materials Purchases Budget Langer Company...Ch. 9 - Direct Labor Budget Evans Company produces asphalt...Ch. 9 - Sales Budget Alger Inc. manufactures six models of...Ch. 9 - Production Budget and Direct Materials Purchases...Ch. 9 - Schedule of Cash Collections on Accounts...Ch. 9 - Schedule of Cash Collections on Accounts...Ch. 9 - Cash Payments Schedule Fein Company provided the...Ch. 9 - Cash Budget The owner of a building supply company...Ch. 9 - Flexible Budget for Various Levels of Production...Ch. 9 - Use the following information for Exercises 9-63...Ch. 9 - Use the following information for Exercises 9-63...Ch. 9 - Prob. 65PCh. 9 - Operating Budget, Comprehensive Analysis Allison...Ch. 9 - Use the following information for Problems 9-67...Ch. 9 - Use the following information for Problems 9-67...Ch. 9 - Use the following information for Problems 9-67...Ch. 9 - Ryan Richards, controller for Grange Retailers,...Ch. 9 - Participative Budgeting, Not-for-Profit Setting...Ch. 9 - Cash Budget The controller of Feinberg Company is...Ch. 9 - Optima Company is a high-technology organization...Ch. 9 - Direct Materials and Direct Labor Budgets Willison...Ch. 9 - Prob. 75PCh. 9 - Prob. 76CCh. 9 - Prob. 77CCh. 9 - Budgetary Performance, Rewards, Ethical Behavior...
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
- Conduct the CVP analysis for your business for the upcoming five years. Specifically, you need to do the following:3.1 Calculate how many units of your product you will need to sell to break even in each of the upcoming five years. Fixed cost $120,000, Variable costs per unit $60, Sales price per unit $100 3.2 Calculate the margin of safety in units for each of the upcoming five years. 3.3 Decide how much you would like to make in before-tax operating income (target profit) in each of the upcoming five years. Calculate how many units you would need to sell in each of the upcoming years to meet those target profit levels.arrow_forwardWoodland Wearables produces two models of a smart watch, the Basic and the Flash. The watches have the following characteristics: Basic Flash Selling price per watch $ 270 $ 460 Variable cost per watch $ 190 $ 220 Expected sales (watches) per year 21,000 7,000 The total fixed costs per year for the company are $1,459,200. Required: What is the anticipated level of profits for the expected sales volumes? Assuming that the product mix is the same at the break-even point, compute the break-even point in units. If the product sales mix were to change to nine Basic watches for each Flash watch, what would be the new break-even volume for Woodland Wearables? A) What is the anticipated level of profits for the expected sales volumes? B) Assuming that the product mix is the same at the break-even point, compute the break-even point in units. Break-even point? units C) If the product sales mix were to change to nine Basic watches for each Flash watch, what would be the new…arrow_forwardAssume that the operations manager of a small semi-conductor manufacturer wants to run a Simulation model to better understand the uncertainties related to cost and demand for a particular product. He assumes that the total cost per month could be anywhere between $150,000 and $200,000 with equal likelihood. He also assumes that the demand is normally distributed with a mean of 5,000 items per month and a standard deviation of 1,000. Each item is sold for $95. a) Use the random numbers in the following table to simulate the costs, revenues and profits per month. Use Random Number A to generate the costs and Random Number B to generate the revenues per month and then calculate the profit as the difference between revenues and costs. Complete the table by reporting the minimum, maximum and average profit per month according to this simulation. Trial 1 2 3 4 5 6 7 8 9 10 you b) Can Random A 0.23 you 0.04 0.14 0.07 0.03 0.67 0.26 0.03 0.83 0.32 Cost Random B 0.75 0.89 0.82 0.33 0.96 0.67…arrow_forward
- Suppose executives estimate that the unit variable cost for their DVD recorder is $100, the fixed cost related to the product is $10 million annually, and the target volume for next year is 100,000 recorders. What sales price will be necessary to achieve a target profit of $l million?arrow_forwardHareshbhaiarrow_forwardWoodland Wearables produces two models of a smart watch, the Basic and the Flash. The watches have the following characteristics: Selling price per watch Variable cost per watch Expected sales (watches) per year Basic $ 260 Flash $ 455 $ 180 18,000 $ 215 6,000 The total fixed costs per year for the company are $1,449,600. Required: a. What is the anticipated level of profits for the expected sales volumes? b. Assuming that the product mix is the same at the break-even point, compute the break-even point in units. c. If the product sales mix were to change to nine Basic watches for each Flash watch, what would be the new break-even volume for Woodland Wearables? Complete this question by entering your answers in the tabs below. Required A Required B Required C What is the anticipated level of profits for the expected sales volumes? Anticipated profitarrow_forward
- PLEASE SOLVE IN EXCEL :B&B has a new baby powder ready to market. If the firm goes directly to the market with the product, there is only a 60 percent chance of success. However, the firm can conduct customer segment research, which will take a year and cost $1.21 million. By going through research, the company will be able to better target potential customers and will increase the probability of success to 75 percent. If successful, the baby powder will bring a present value profit (at time of initial selling) of $19.1 million. If unsuccessful, the present value payoff is only $6.1 million. The appropriate discount rate is 14 percent. Calculate the NPV for the firm if it goes to market immediately and if it conducts customer segment research. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) Should the firm conduct customer segment research or go to the market immediately? multiple…arrow_forwardJohn Deere Tractors is considering the introduction of a mid-priced version of the firm's DC6900 lawn and garden tractor product line the DC6900-X. The DC6900-X would sell for $3,900 with unit variable costs of $1,800. Projections made by an independent marketing research firm indicate that the DC6900-X would achieve a sales volume of 500,000 units next year, in its first year of commercialization. One-half of the first year's volume would come from competitors' products and market growth. However, a consumer research study indicates that 30 percent of the DC6900-X sales volume would come from the higher-priced DC600-Omega tractor, which sells for $5,900 (with unit variable costs of $2,200). Another 20 percent of the DC00-X sales volume would come from the economy-priced DC6900-Alpha tractor, priced at $2,500 (with unit variable costs of $1,200). The DC6900-Omega unit volume is expected to be 400,000 units next year, and the DC6900-Alpha is expected to achieve a 600,000-unit sales…arrow_forwardThe management of Madeira Computing is considering the introduction of a wearable electronic device with the functionality of a laptop computer and phone. The fixed cost to launch this new product is $300,000. The variable cost for the product is expected to be between $167 and $247, with a most likely value of $207 per unit. The product will sell for $300 per unit. Demand for the product is expected to range from 0 to approximately 20,000 units, with 4,000 units the most likely. (a) Compute profit (in $) for this product in the base-case scenario. $ (b) Compute profit (in $) for this product in the worst-case scenario. $ (c) Compute profit (in $) for this product in the best-case scenario. $ (d) Model the variable cost as a uniform random variable with a minimum of $167 and a maximum of $247. Model the product demand as 1,000 times the value of a gamma random variable with an alpha parameter of 3 and a beta parameter of 2. Construct a simulation model to estimate…arrow_forward
- Develop a worksheet simulation for the following problem: The management of Montemayor Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is ₱30,000. The variable cost for the product is uniformly distributed between ₱16 and ₱24 per unit. The product will sell for ₱50 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1,200 units and a standard deviation of 300 units. Develop a spreadsheet simulation similar to the one provided previously. Use 500 simulation trials to answer the following questions. What is the mean profit for the simulation? What is the probability that the project will result in a loss? What is your recommendation concerning the introduction of the product?arrow_forwardB&B has a new baby powder ready to market. If the firm goes directly to the market with the product, there is only a 55 percent chance of success. However, the firm can conduct customer segment research, which will take a year and cost $1.18 million. By going through research, the company will be able to better target potential customers and will increase the probability of success to 70 percent. If successful, the baby powder will bring a present value profit (at time of initial selling) of $18.8 million. If unsuccessful, the present value payoff is only $5.8 million. The appropriate discount rate is 15 percent. Calculate the NPV for the firm if it goes to market immediately and if it conducts customer segment research. (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)arrow_forwardSwifty Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Patricia Johnson, the company’s sales manager, prepared the following sales forecast for 2022. The forecasted sales prices include a 5% increase in the acoustic guitar price and a 10% increase in the electric guitar price, to cover anticipated increases in raw materials prices. Sales Price 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Acoustic guitar sales $1,200 200 280 320 350 Electric guitar sales $2,150 400 350 320 360 Please help me fill out the red shown in the picture.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Cost-Volume-Profit (CVP) Analysis and Break-Even Analysis Step-by-Step, by Mike Werner; Author: Accounting Step by Step;https://www.youtube.com/watch?v=D0MOfse9OWk;License: Standard Youtube License