Carol is a baker who owns a small bakery called Pie in the Sky that sells cherry pies. She has been debating adding new pies into herofferings, including blackberry and apple. Carol is preparing a budgeted income statement for April so she can compare budgeted netincome, when selling just cherry pies, to budgeted net income when selling other types of pies as well. She has decided that she will beable to sell the pies for the following prices: Cherry, $10; Blackberry, $8; and Apple, $11. Carol will be able to produce 440 pies amonth regardless of what kinds of pies she chooses to bake and sell. The pies have the following costs associated with them:Cherry (per pie)Crust $0.20Filling $0.65Topping $0.40RentCarol took out a $9,000 loan with an Annual Percentage Rate (APR) of 12% to begin her business, and she will have a flat tax rate of21%. Her monthly fixed selling, general, and administrative (SG&A) expenses include the following:Phone and UtilitiesBlackberry (per pie)Apple (per pie)$0.20Crust $0.20$0.72Filling$0.70$0.24 Topping $0.34InsuranceBaking SuppliesCrustFillingTopping$2,200$480$130$680 (b)Assuming that Carol proceeds with selling only cherry pies, what would her gross margin and budgeted net income be for April?(Round answers to 2 decimal places, e.g. 52.75.)Gross marginBudgeted net income for AprilSave for Later$$Attempts: 0 of 1 used Submit Answer

The budgeted net income is computed by deducting the administrative and selling expenses from the…

Carol is a baker who owns a small bakery called Pie in the Sky that sells cherry pies. She has been debating adding new pies into her offerings, including blackberry and apple. Carol is preparing a budgeted income statement for April so she can compare budgeted net income, when selling just cherry pies, to budgeted net income when selling other types of pies as well. She has decided that she will be able to sell the pies for the following prices: Cherry, $10; Blackberry, $8; and Apple, $11. Carol will be able to produce 440 pies a month regardless of what kinds of pies she chooses to bake and sell. The pies have the following costs associated with them: Cherry (per pie) Blackberry (per pie) Apple (per pie) Crust $0.20 $0.20 Crust $0.20 Filling $0.65 Filling $0.72 Filling $0.70 Topping $0.40 Topping $0.24 Topping $0.34 Carol took out a $9,000 loan with an Annual Percentage Rate (APR) of 12% to begin her business, and she will have a flat tax rate of 21%. Her monthly fixed selling, general, and administrative (SG&A) expenses include the following: Rent Phone and Utilities Insurance Crust Baking Supplies $2,200 $480 $130 $680

Carol is a baker who owns a small bakery called Pie in the Sky that sells cherry pies. She has been debating adding new pies into her offerings, including blackberry and apple. Carol is preparing a budgeted income statement for April so she can compare budgeted net income, when selling just cherry pies, to budgeted net income when selling other types of pies as well. She has decided that she will be able to sell the pies for the following prices: Cherry, $10; Blackberry, $8; and Apple, $11. Carol will be able to produce 440 pies a month regardless of what kinds of pies she chooses to bake and sell. The pies have the following costs associated with them: Cherry (per pie) Blackberry (per pie) Apple (per pie) Crust $0.20 $0.20 Crust $0.20 Filling $0.65 Filling $0.72 Filling $0.70 Topping $0.40 Topping $0.24 Topping $0.34 Carol took out a $9,000 loan with an Annual Percentage Rate (APR) of 12% to begin her business, and she will have a flat tax rate of 21%. Her monthly fixed selling, general, and administrative (SG&A) expenses include the following: Rent Phone and Utilities Insurance Crust Baking Supplies $2,200 $480 $130 $680

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 2P: The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising...

See similar textbooks

Similar questions

Leyia and Larry Hartley of Columbus, Ohio have decided to start a family next year, so they are looking over their budget. Leyia thinks that she can go on half-salary ($2,400 instead of $4,800 per month) in her job as a college textbook sales representative for about 18 months after the baby's birth; she will then return to full-time work. Looking at the Hartley's current monthly budget, identify categories and amounts in their budget where they realistically might cut back $2,400. (Hint: Federal and state taxes should drop about $600 a month ($7,200 annually) as their income drops.)
Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month: Month January February March April # of cupcakes 6,950 7,950 7,050 7,450 All cupcakes are sold each month and she has no beginning or ending cupcake inventory. Tracy would like for you to create a cash collections budget if she sells each cupcake for $2.28 each. She anticipates that 80% of her sales will be cash sales and the remaining 20% will be on account. Of the 20% on account, she believes she will receive 70% the month of sales and 30% the second month. The beginning accounts receivable is $2,000. Explain where you give Tracy the requested…
Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month: Month January February March April # of cupcakes 6,950 7,950 7,050 7,450 All cupcakes are sold each month and she has no beginning or ending cupcake inventory. Tracy would like for you to create a cash collections budget if she sells each cupcake for $2.28 each. She anticipates that 80% of her sales will be cash sales and the remaining 20% will be on account. Of the 20% on account, she believes she will receive 70% the month of sales and 30% the second month. The beginning accounts receivable is $2,000. Lastly, she would like for you to create a…
Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month Month January February March April # of cupcakes 6,950 7,950 7,050 7,450 Explain where you give Tracy the requested budgets and explain how you determined the amounts?
Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month: Month January February March April # of cupcakes 6,950 7,950 7,050 7,450 All cupcakes are sold each month and she has no beginning or ending cupcake inventory. Tracy would like for you to create a cash collections budget if she sells each cupcake for $2.28 each. She anticipates that 80% of her sales will be cash sales and the remaining 20% will be on account. Of the 20% on account, she believes she will receive 70% the month of sales and 30% the second month. The beginning accounts receivable is $2,000. 1. Explain how to do the steps that all
Tracy is preparing her budget for next year and needs your assistance. Now that she has a better idea of what to expect now that she is in business full time, we want to begin having some of her ingredients in stock to avoid not being able to get the ingredients on time. She is ready to prepare her budget for the first four months of 2021. She believes she will sell the following number of cupcakes each month: Month January February March April # of cupcakes 6,950 7,950 7,050 7,450 All cupcakes are sold each month and she has no beginning or ending cupcake inventory. Tracy would like for you to create a cash collections budget if she sells each cupcake for $2.28 each. She anticipates that 80% of her sales will be cash sales and the remaining 20% will be on account. Of the 20% on account, she believes she will receive 70% the month of sales and 30% the second month. The beginning accounts receivable is $2,000. Lastly, she would like for you to create a…
Jana and Cindy are planning to launch UP-PACK, a business that upcycles disposable masks into high quality packaging material. They think it can be a viable business but they need your advice; they want to make sure they aren't taking too big of a risk. Use the information below to create a 6 month cash budget. Based on their research of the industry, they plan to provide credit terms to their customers of 35% payment during the month of sale and 65% payment in the month following sale. Manufacturing supply costs are relatively low since they can get free used disposable masks from health care facilities but there are costs incurred to clean and upcycle the masks. They project their costs of goods sold (COGS) to be 24% of each month's sales. They anticipate having to pay 60% of these costs in the month of purchase and 40% in the month following purchase. Fortunately, Jana's brother has a large empty garage that they can operate in for the first year which saves them from renting…
The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of 1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least twice the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure? a. Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. b. Develop a spreadsheet model and solve the problem using Excel Solver.
Since employees do not pay for their food directly, what will Jennifer likely use as the “revenue” portion of her budget? How do you think this number should be determined? In addition to her know-how as a food service director, what skills will Jennifer likely need as she interacts with the executives at Techmar who must approve her operating budget?
In your report to the CEO, you are to provide the following:A flexible budget based on the actual volume that was sold last year for both leather and vegan-polymer purses;
The director of marketing for Starr Computer Co., Megan Hewitt, had the following discussion with the company controller, Cam Morley, on July 26 of the current year: Megan: Cam, it looks like I’m going to spend much less than indicated on my July budget. Cam: I’m glad to hear it. Megan: Well, I’m not so sure it’s good news. I’m concerned that the president will see that I’m under budget and reduce my budget in the future. The only reason that I look good is that we’ve delayed an advertising campaign. Once the campaign hits in September, I’m sure my actual expenditures will go up. You see, we are also having our sales convention in September. Having the advertising campaign and the convention at the same time is going to kill my September numbers. Cam: I don’t think that’s anything to worry about. We all expect some variation in actual spending month to month. What’s really important is staying within the budgeted targets for the year. Does that look as if it’s going to be a problem?…
The director of marketing for Starr Computer Co., Megan Hewitt, had the following discussion with the company controller, Cam Morley, on July 26 of this year: Megan: Cam, It looks like I am going to spend much less than indicated on my July budget. Cam: I'm glad to hear it. Megan: Well, I'm not so sure it's good news. I'm concerned that the president will see that I'm under budget and reduce my budget in the future. The only reason that I look good in that we've delayed an advertising campaign. Once the campaign hits in September, I'm sure my actual expenditures will go up. You see, we are also having our sales convention in September. Having the advertising campaign and the convention at the same time is going to kill my September numbers. Cam: I don't think that's anything to worry about. We all expect some variation in actual spending month to month. What's really important is staying within the budgeted targets for the year. Does that look as if it's going to be a problem? Megan: I…