A portable speaker or ear buds-which to buy? This is a question for many teens as well as their gift-giving relatives. A similar ques weighs on the minds of manufacturers, only their perspective relates to planning for production and sales for the upcoming year. Whispering is one such manufacturer. Before setting firm budgets and targets for the coming year, company management reviews year just ended. Key information related to last year is as follows. Budgeted volume (units) Actual volume (units) Budgeted selling price (per unit) Actual selling price (per unit) Budgeted variable cost (per unit) Actual variable cost (per unit) (a) Speaker 12,000 11,200 $80 $82 $33 $33 Master Budget Ear Buds 8,000 6,300 $80 $82 $21 $21 Set up a partial income statement through contribution margin for Whispering, recognizing appropriate amounts for the actual income statement, flexible budget, and master budget. Use Excel to reference input cells for each calculation needed for these partial income statements. Total

A portable speaker or ear buds-which to buy? This is a question for many teens as well as their gift-giving relatives. A similar ques weighs on the minds of manufacturers, only their perspective relates to planning for production and sales for the upcoming year. Whispering is one such manufacturer. Before setting firm budgets and targets for the coming year, company management reviews year just ended. Key information related to last year is as follows. Budgeted volume (units) Actual volume (units) Budgeted selling price (per unit) Actual selling price (per unit) Budgeted variable cost (per unit) Actual variable cost (per unit) (a) Speaker 12,000 11,200 $80 $82 $33 $33 Master Budget Ear Buds 8,000 6,300 $80 $82 $21 $21 Set up a partial income statement through contribution margin for Whispering, recognizing appropriate amounts for the actual income statement, flexible budget, and master budget. Use Excel to reference input cells for each calculation needed for these partial income statements. Total

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 38P: Friendly Bank is attempting to determine the cost behavior of its small business lending operations....

See similar textbooks

Similar questions

Please help solve all question Mega Empire Bhd. is in the inital stages of preparing the annual budget for next year. Danial, has recently joined the company as management accountant and is interested to learn as much as possible about the company’s budgeting process. After the recent meeting with the Sales Manager who is Zack and Aaron as the Production Manager, Danial initiated the following conversation Danial: Since I am new around here and I am going to be involved with the preparation of the annual budget. I’d be interested to learn how the two of you estimate sales and production numbers. Zack: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then we add the usual dose of intuition to come up with the best forecast we can. Aaron: I usually take the sales projections as a basis for my projections. Of course we have to make estimate of what this year’s…
Information for Budgeting, Ethics Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Norton’s account-ing staff and is interested in learning as much as possible about the company’s budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, productionmanager, Ford initiated the following conversation.FORD: “Since I’m new around here and am going to be involved with the preparation of the annual budget, I’d be interested in learning how the two of you estimate sales and productionnumbers.”ATKINS: “We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending.Then, we add that usual dose of intuition to come up with the best forecast we can.”GRANGER: “I usually take the sales projections as the basis for my projections. Of…
How does the budgeting process translate long-term goals into operating objectives? Suppose Framecraft has an Information Processing Division that provides database management services for the professional photographers and artists who buy its frames. The division uses state-of-the-art equipment and employs five information specialists. Each specialist works an average of 160 hours a month. The division’s controller has com piled the following information: Actual Data for Past Year Forecasted Data for This Year November December January February March Client billings (sales) $25,000 $35,000 $25,000 $20,000 $40,000 Selling and administrative expenses 12,000 13,000 12,000 11,000 12,500 Operating supplies 2,500 3,500 2,500 2,500 4,000 Processing overhead 3,200 3,500 3,000 2,500 3,500 Of the client billings, 60 percent are cash sales collected during the month of sale, 30 per cent are collected in the first month following the sale, and 10 percent are collected in the second month…
Assume that you manage one store in a chain of sporting goods retailers. Each month, your store is evaluated by comparing actual operating results to budgeted results. During December of the current year, your store’s sales were up 25% from sales projected on the budget. As a result of this increase in sales, would you expect any other items to come in over (or under) their budgeted amounts? If so, list the items and describe why they would vary from the budget.
You have been hired by the McClosky Corporation and they manufacture industrial dye. Milestone 3:I. Budgeted Balance SheetJ. Cash BudgetK. Budget Presentation and please address the following questions:(1) The sales manager would like to increase the sales price by 10 next quarter, what will be the projected revenues be for the 2nd quarter. (2) The production manager would like to purchase new equipment for next quarter due to the fact that their competitor has purchased equipment which cost $50,000. Will the company be able to make the purchase or will you need more information?(3) The CEO feels that the cash budget is not necessary, please explain to the CEO why cash budgeting is important to the organization.(4) Please explain the to the management team how a competitor’s actions can affect business planning.
KK ENTERPRISE was set up by a man and his with some few years ago. The trade in a lot of products. They don’t have enough knowledge in accounting for decision making. They need professional assistance to prepare budgets for the period October to December 2020. The following information has been provided to assist in the budgeting process: · Budgeted monthly sales revenue for 2020 is as follows: October GH¢ 40,000, November GH¢ 70,000, December GH¢ 50,000, January 2018 45,000. Sales are 20% cash and 80% credit. Credit sales are collected over a three- month period, 15% in the month of sale, 70% in the month following sale and 15% in the second month following sale. Total sales revenue in August amounts to GH¢30,000 and September’s total sales revenue amounts to GH¢36,000. Cost of sales is expected to amount to 60% of sales revenue each month. The business maintains its closing inventory levels at 75% of the following month’s cost of sales. Inventory at the beginning of October is…
Behavioral Aspects of Budgeting; Ethics and the Manager Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for next year. Scott Ford has recently joined Norton’s accounting staff and wants to learn as much as possible about the company’s budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. Ford: Since I’m new around here and am going to be involved with the preparation of the annual budget, I’d be interested to learn how the two of you estimate sales and production numbers. Atkins: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. Granger: I usually rake the sales projections as the basis for my projections. Of…
Review the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)
CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)
Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?
The Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.