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
Assume 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…
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?
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?
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
- 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 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_forwardCoronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Sharon Lee, 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,250   240   270   310   340   Electric guitar sales  $2,100   400    350   320   360  On December 31, 2021, Coronado had 30 acoustic guitars in stock—fewer than the desired inventory level of 96 guitars, based on the following quarter’s sales. The company has budgeted for sales of 240 acoustic guitars in the first quarter of 2023. Prepare the 2022 production budget for acoustic guitars.  Production…arrow_forward
- Coronado Enterprises is a boutique guitar manufacturer. The company produces both acoustic and electric guitars for rising and established professional musicians. Sharon Lee, 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,250   240   270   310   340   Electric guitar sales  $2,100   400   350   320   360   (a)   Prepare Coronado’s sales budget for 2022. Sales Budget  1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Annual Acoustic:      select a sales budget item                                                enter a number of units enter a number of units…arrow_forwardPLEASE 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_forwardBLTD is investigating the financial viability of a new product called Wimble.The Wimble is a short life product for which a market has been identified at an agreed design specification.The product will only have a life of 12 months.The following estimated information is available in respect of Wimble.• Sales should be 120,000 in the year in batches of 100 units. An average selling price of K1,050 per batch of 100 units is expected. All sales are for cash.• An 80% learning curve will apply for the first 700 batches after which a steady state production time will apply, with the labour time per batch after the first 700 batches equal to the time for the 700th The cost of the first batch was measured at K2,500.This was for 500 hours at K5 per hour.• Variable overhead is estimated at K2 per labour hour.• Direct material will be K500 per batch of wimble for the first 200 batches produced. The second 200 batches will cost 90% of the cost per batch of the first 200 batches. All batches from…arrow_forward
- After conducting a market research study, Bauman Manufacturing decided to produce a new interior door to complement its exterior door line. It is estimated that the new interior door can be sold at a target price of $120. The annual target sales volume for interior doors is 20,000. Stewart has a 20% expected return on sales target.arrow_forwardThe following table presents sales forecasts for Golden Gelt Giftware. The unit price is $30. The unit cost of the giftware is $25. Year Unit Sales 20, 000 2. 31, 200 14, 900 5, 700 Thereafter It is expected that net working capital will amount to 25% of sales in the following year. For example, the store will need an initial (year 0) investment in working capital of 0.25 x 20,000 x $30 = $150,000. Plant and equipment necessary to establish the giftware business will require an additional investment of $197,000. This investment will be depreciated in an asset class with a CCA rate of 25%. We will assume that the firm has other assets in this asset class. After 4 years, the equipment will have an economic and book value of zero. The firm's tax rate is 35%. The discount rate is 10%. What is the net present value of the project? (Round your answer to the nearest whole dollar amount.) NPV $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 65 percent chance of success. However, the firm can conduct customer segment research, which will take a year and cost $1.13 million. By going through research, B&B will be able to better target potential customers and will increase the probability of success to 80 percent. If successful, the baby powder will bring a present value profit (at time of initial selling) of $18.3 million. If unsuccessful, the present value payoff is $5.3 million. The appropriate discount rate is 13 percent. Calculate the NPV for the firm if it conducts customer segment research and if it goes to market immediately. (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.) Market immediately Research option Should the firm conduct customer segment research or go to the market immediately? O Market…arrow_forward
- 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 55 percent chance of success. However, the firm can conduct customer segment research, which will take a year and cost $875,000. By going through research, B&B 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 $16.5 million. If unsuccessful, the present value payoff is $7.5 million. The appropriate discount rate is 13 percent.   Calculate the NPV for the firm if it conducts customer segment research and if it goes to market immediately. (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 choice…arrow_forwardGidget has a new widget to bring to market. If the firm goes directly to market with the product, there is a 60% chance of success. However, the firm can conduct customer segment research, which will take a year and cost $5,000,000. By going through research, the company can better target potential customers and increase the probability of success to 75%. If successful, the widget will bring a present value profit (at the time of initial selling) of $90 million. If unsuccessful, the present value profit is only $15 million. The appropriate discount rate is 10%. Calculate the NPV for conducting customer segment research. (Enter whole numbers, e.g. 5 million should be 5,000,000)arrow_forwardC&D has a new baby powder ready to market. If the firm goes directly to the marketwith 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 $550,000. By going through research, B&B 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 $26 million. If unsuccessful, the present value profit is only $4.2 million. Should the firm conduct customer segment research or go directly to market? The appropriate discount rate is 12 percent.  answer on an excel filearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
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