Sanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer (Price - Cost of Goods) $6.5 Number of Scenario Customers Good 45, 000 35, 000 30, 000 Fair 5.5 Poor 1.9 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $45,000 plus $2 for every customer in excess of 35,000. The marketing and administrative costs are estimated to be $12,900 plus 3 percent of the gross margin.

Sanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer (Price - Cost of Goods) $6.5 Number of Scenario Customers Good 45, 000 35, 000 30, 000 Fair 5.5 Poor 1.9 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $45,000 plus $2 for every customer in excess of 35,000. The marketing and administrative costs are estimated to be $12,900 plus 3 percent of the gross margin.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 33P: Biotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the...

See similar textbooks

Similar questions

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?
Biotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the other in Bernalillo, New Mexico. The owner of Biotechtron centralized the legal services function in the Yuma office and had both laboratories send any legal questions or issues to the Yuma office. The legal services support center has budgeted fixed costs of 160,000 per year and a budgeted variable rate of 65 per hour of professional time. The normal usage of the legal services center is 2,600 hours per year for the Yuma office and 1,400 hours per year for the Bernalillo office. This corresponds to the expected usage for the coming year. Required: 1. Determine the amount of legal services support center costs that should be assigned to each office. 2. Since the offices produce services, not tangible products, what purpose is served by allocating the budgeted costs? 3. Now, assume that during the year, the legal services center incurred actual fixed costs of 163,000 and actual variable costs of 272,400. It delivered 4,180 hours of professional time2,580 hours to Yuma and 1,600 hours to Bernalillo. Determine the amount of the legal services centers costs that should be allocated to each office. Explain the purposes of this allocation. 4. Did the costs allocated differ from the costs incurred by the legal services center? If so, why?
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.
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. If the promotional budget is limited to $18,200, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media, and what is the total audience reached? By how much would audience contact increase if an extra $100 were allocated to the promotional budget?
Sanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer Scenario (Price – Cost of Goods) Number of Customers Good $5 30,000 Fair 4 20,000 Poor 2 15,000 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $25,000 plus $2 for every customer in excess of…
Sanjana’s Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer Scenario (Price – Cost of Goods) Number of Customers Good $6.7 47,000 Fair 5.7 37,000 Poor 1.9 32,000 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $47,000 plus $2 for every customer in excess of…
Week 6 South Hampton University is preparing its budget for the upcoming academic year. This is a specialised private university that charges fees for all degree courses. Currently, 30,000 students are enrolled on campus. However, the university is forecasting a 5 per cent growth in student numbers in the coming year, despite an increase in fees to $3,000 per subject. The following additional information has been gathered from an examination of university records and conversations with university managers:  South Hampton is planning to award scholarships to 200 students, which will cover their fees.  The average class has 80 students, and the typical student takes 4 subjects per semester. South Hampton operates 2 semesters per year.  The average academic staff salary is $120,000 per annum including on-costs.  South Hampton’s academic staff are evaluated on the basis of teaching, research, administration and professional/community service. Each of the academic staff…
(J) Citations are required for this exercise. Comments to other students must be detailed and substantive. Alpaca Industries, located in the beauty pacific Northwest, manufactures a household electronic device. The company is fairly small with revenues and total assets of approximately $370,000 and $300,000, respectively. The company has never maintained a budget since its inception, and as a new hire, you are eager to create a budget for the company. Write a 1-page memo, explaining to the owner the advantages of budgeting. In your memo, provide exact page number citations. Please note that any responses without citations will not be graded. Only the original responses are graded; subsequent edits are not graded.
Problem 1 Glidden Company manufactures a line of chocolate bars that are sold in various department and grocery stores. The company’s controller has just received the sales forecast for the coming year for Glidden Company’s three products which are the High Protein, High Sugar and No Sugar chocolate bars. Glidden has experienced large fluctuations in sales volumes and variable costs over the past two years and the controller believes the sales forecast should be carefully evaluated from a CVP perspective. Preliminary budget information for 2023 is as follows: High Sugar High Protein No Sugar Unit sales 100,000 100,000 200,000 Unit selling price $ 48 $ 56 $ 68 Variable manufacturing cost per unit $ 11 $ 10 $ 21 Variable selling cost per unit $ 7 $ 6 $ 10 For 2023, Glidden’s fixed factory overhead is budgeted at $ 2,000,000 and the company’s fixed, selling and administrative expenses are forecasted to be $ 600,000. Glidden’s income tax rate is 40%. Required: (Show all calculations.…
Using the excel sheet Create a budget for cybersecurity based on these assumptions There are 5 members in the department: One Director that gets paid $130,000/year. One Supervisor that gets paid $95,000/year. Three Junior Staff members that get paid $65,000/year each. There are three conferences in 2021 and you will be sending 2 employees to each conference. The first two conferences cost $3,000 per person and the third conference is $5,000 per person. The conferences will be held in February, May, and September Meals will be paid for travel to the conferences mentioned above. Each person will receive $250 per day and each conference is five days. The entire department will be attending a training seminar in April and the cost is $5,000 per person During the training session for the entire department, each person will receive $250 per day for meals and the training session is for three days. Each person in the department spends $24 per month each for supplies The company always…
Adams Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1. The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the following tasks. Required October sales are estimated to be $200,000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 25 percent per month. Prepare a sales budget. The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale. Prepare a schedule of cash receipts. The cost of goods sold is 60 percent of sales. The company desires to maintain a minimum ending inventory equal to 10 percent of the next month’s cost of goods sold. However, ending inventory of December is expected to be $12,000. Assume that all purchases are made…
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…