Mark Make-a-Buck sells jars of beach sand in Florida. His price per jar is $2.50. His...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mark Make-a-Buck sells jars of beach sand in Florida. His price per jar is $2.50. His historical costs have been: $.40 per item $.10 per item $.30 per item $.20 per item $500 per month $1,000 per month Jar Сар Label Sales commission to retailers Excavating machine depreciation Mark's salary (President) 1. a. What is Mark's breakeven point for the month, in terms of both quantity and sales dollars on a pretax basis? b. Mark wants to make a target profit of $2,000 after tax for the month. How many jars of beach sand would he need to sell? Mark's tax rate is 20%. c. Mark generated revenues of $5,000 in September, 2019. What was his margin of safety in both dollars and sales quantity? d. What was Mark's operating leverage in September 2019? 2. Mark is concerned about 2020, as tourism is down due to the pandemic. He feels that he will only be able to sell 500 jars per month. He wants to run some scenarios and figure out what changes he needs to make to remain profitable. Prepare income statements for the following scenarios (one column per scenario): a. Sales of beach sand fall to 500 jars per month with current cost structure; b. Mark uses a cheaper label and jar, reducing those costs 20% each. Sales are at 500 units per month; c. Your choice. Run a scenario detailing what factors you would recommend that Mark look into changing. Assume sales at 500 jars per month. 3. Conclusion. What do you think Mark should do? Should he remain in the business? Be detailed and state your reasons logically. Worksheet Format 1. Set up your Excel workbook with 4 worksheets Input Calculations (requirement 1 above) Seonories thore ore 2 goonories (reguiromont 2 ohovo) Worksheet Format 1. Set up your Excel workbook with 4 worksheets Input Calculations (requirement 1 above) Scenarios – there are 3 scenarios (requirement 2 above) Summary and conclusion 2. For the input area, include your prices, variable costs, fixed costs, sales volumes and scenario assumptions. 3. The calculations and scenarios tab must reference back (link) to the input tab. 4. The summary must look like this: Question 1: Quantity Revenues Other Breakeven Point XX XX Target profit $2,000 XX N/A Margin of Safety XX XX Operating leverage NA N/A XXX Question 2: Operating Income Scenario 1 XX Scenario 2 XX Scenario 3 XX Conclusion: Link all your numbers to your calculation tabs. GRADING 1. Excel set up properly with 4 separate worksheets within the workbook. Uses linking Mark Make-a-Buck sells jars of beach sand in Florida. His price per jar is $2.50. His historical costs have been: $.40 per item $.10 per item $.30 per item $.20 per item $500 per month $1,000 per month Jar Сар Label Sales commission to retailers Excavating machine depreciation Mark's salary (President) 1. a. What is Mark's breakeven point for the month, in terms of both quantity and sales dollars on a pretax basis? b. Mark wants to make a target profit of $2,000 after tax for the month. How many jars of beach sand would he need to sell? Mark's tax rate is 20%. c. Mark generated revenues of $5,000 in September, 2019. What was his margin of safety in both dollars and sales quantity? d. What was Mark's operating leverage in September 2019? 2. Mark is concerned about 2020, as tourism is down due to the pandemic. He feels that he will only be able to sell 500 jars per month. He wants to run some scenarios and figure out what changes he needs to make to remain profitable. Prepare income statements for the following scenarios (one column per scenario): a. Sales of beach sand fall to 500 jars per month with current cost structure; b. Mark uses a cheaper label and jar, reducing those costs 20% each. Sales are at 500 units per month; c. Your choice. Run a scenario detailing what factors you would recommend that Mark look into changing. Assume sales at 500 jars per month. 3. Conclusion. What do you think Mark should do? Should he remain in the business? Be detailed and state your reasons logically. Worksheet Format 1. Set up your Excel workbook with 4 worksheets Input Calculations (requirement 1 above) Seonories thore ore 2 goonories (reguiromont 2 ohovo) Worksheet Format 1. Set up your Excel workbook with 4 worksheets Input Calculations (requirement 1 above) Scenarios – there are 3 scenarios (requirement 2 above) Summary and conclusion 2. For the input area, include your prices, variable costs, fixed costs, sales volumes and scenario assumptions. 3. The calculations and scenarios tab must reference back (link) to the input tab. 4. The summary must look like this: Question 1: Quantity Revenues Other Breakeven Point XX XX Target profit $2,000 XX N/A Margin of Safety XX XX Operating leverage NA N/A XXX Question 2: Operating Income Scenario 1 XX Scenario 2 XX Scenario 3 XX Conclusion: Link all your numbers to your calculation tabs. GRADING 1. Excel set up properly with 4 separate worksheets within the workbook. Uses linking
Expert Answer:
Answer rating: 100% (QA)
Questin 3 nlusin Mrk shuld ntinue with the business lthugh ... View the full answer
Related Book For
Financial Algebra advanced algebra with financial applications
ISBN: 978-0538449670
1st edition
Authors: Robert K. Gerver
Posted Date:
Students also viewed these accounting questions
-
Q13 For the beam section shown in Figure Q13, the structure has been idealised into booms (B1-B5) which carry all the direct stresses and thin web sections between which only resist shear forces. The...
-
1. How many shares of each stock would he get if he used the $28 500 and invested equally in all four companies? 2. Suppose Amarjit decided to buy shares in only TELUS and Goldcorp. How many shares...
-
Breakeven analysis, target profit Last year, Able Co. recorded sales revenues of $1,260,000, variable costs of $570,000, and fixed costs of $480,500. Required (a) At what sales dollar level will Able...
-
Which statement about cylindrical coordinates is correct? (a) If = 0, then P lies on the z-axis. (b) If = 0, then P lies in the xz-plane.
-
A furniture manufacturing company manufactures dining-room tables and chairs. A table requires 8 labor-hours for assembling and 2 labor-hours for finishing. A chair requires 2 labor-hours for...
-
A penny rides on top of a piston as it undergoes vertical simple harmonic motion with an amplitude of 4.0 cm. If the frequency is low, the penny rides up and down without difficulty. If the frequency...
-
Review the information on YouTube in this section of the chapter and conduct your own research. What evidence is there that beginning with the end in mind was part of YouTubes founders original plan?
-
Anticipated sales for Sure Grip Tire Company were 42,000 passenger car tires and 15,000 truck tires. There were no anticipated beginning or ending finished goods inventories for either product....
-
Produce a high level project plan for the design, implementation, commissioning of the data centre. References - Schneider Electric - Data Centre Projects, Schneider Electric, Schneider Electric -...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Just-in-time systems allow for maintaining a level of inventory that will tide a firm over in the case of shortages brought about by disruption among suppliers. 1. True 2.False
-
Compared to using a finance lease, a lessee that makes use of an operating lease will most likely report higher: A. debt. B. rent expense. C. cash flow from operating activity.
-
Which combination of depreciation methods and useful lives is most conservative in the year a depreciable asset is acquired? A. Straight-line depreciation with a short useful life. B. Declining...
-
A core objective of the International Organization of Securities Commissions is to: A. eliminate systematic risk. B. protect users of financial statements. C. ensure that markets are fair, efficient,...
-
Expenses on the income statement may be grouped by: A. nature, but not by function. B. function, but not by nature. C. either function or nature.
-
A financial analyst at BETTO, S.A. is analyzing the result of the sale of a vehicle for 85,000 Argentine pesos (ARP) on 31 December 2009. The analyst compiles the following information about the...
-
The Splendid woods is the most popular carpenters in producing coffee tables for restaurants. It sells two varieties of tables one made of pine and other of oak. Pine table sells for $35 per table...
-
we have to compute the letter grades for a course. The data is a collection of student records stored in a file. Each record consists of a name(up to 20 characters), ID (8 characters), the scores of...
-
Write a formula that will convert the volume given in 1,000s into a volume given in 100s. Use the left side of the equation to indicate in which cell to store the formula. a. Intel Corp b. Yahoo! Inc...
-
Express the missing entries in the debit card register algebraically. NIBERORDAT DESCRIPTION 12/3 Arlof's ifts 12/6 Bonnie's Boutique 12/ Gas 12/11 Cable TV 2/12 Deposi 2/14 Gas a. b. c. d. e. f.
-
Anton works at First National Bank. His employer offers him a pension retirement plan which will be 1.45% of his average salary for the last five years of employment for every year worked. Anton is...
-
The data file \(b r 2\) contains data on 1080 house sales in Baton Rouge, Louisiana, during July and August 2005. The variables are: PRICE (\\($)\), SQFT (total square feet), BEDROOMS (number), BATHS...
-
Explain how and why plots of least squares residuals can reveal heteroskedasticity.
-
How much of an incumbency advantage do winners in U.S. Senate elections enjoy? This issue is examined by Matias D. Cattaneo, Brigham R. Frandsen and Roco Titiunik (2015) "Randomization Inference in...
Study smarter with the SolutionInn App