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.
-
Covariance of estimated population totals in a cluster sample. Suppose a one-stage cluster sample is taken from a population of N psus, with inclusion probabilities Ïi. Let tx and ty be the...
-
The band director at a high school wants to estimate the percentage of parents who support a decrease in the budget for fine arts. Because many parents attend the schools annual musical, the director...
-
\((-13)+(-102)\) Complete the indicated calculation.
-
On June 10, Rebecca Company purchased $7,600 of merchandise from Clinton Company, FOB shipping point, terms 2/10, n/30. Rebecca pays the freight costs of $400 on June 11. Damaged goods totaling $300...
-
. P&G Corporation, a C corporation, sold the following business assets in 2021. Compute the amount and character of the gain or loss P&G Corporation must report from the disposition of each ...
-
There is a parcel of land next to the Playful Paws, Inc. building. Ellen, the owner of this property, approached John to discuss the idea of selling it to him. John is interested. Ellen knows that...
-
The wing must be completely balanced, even when multiple torques act on it. The wing is uniform with dimensions d and h and is attached to the craft at the middle of it's side with a hinge, and with...
-
Which graphical tool commonly used in project management is also very useful in shop-floor control?
-
How does attribution theory allow managers to justify workers behaviors?
-
What are common methods to measure a persons attitude?
-
What do we generally call an area in a business where productive resources are organized and work is completed?
-
Why is stereotyping so problematic for the healthcare industry?
-
??????? In each year \( t \in\{1, \ldots, N\} \), a farmer produces \( s_{t} \) units of a certain crop. Out of the \( s_{t} \) units that are produced in year \( t \), the farmer stores \(...
-
The Home Depot is the leading retailer in the home improvement industry and one of the 10largest retailers in the United States. The company included the following on its January 29, 2012, balance...
-
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...
-
Using Google, determine the number of hits for these terms: a. Forensic accounting. b. Fraud auditing. c. Forensic auditing. d. Fraud examination.
-
Search the Internet: Is plagiarism fraud?
-
Search the Internet and learn about the AICPA's site on Business Valuation and Forensic/Litigation Services.
Study smarter with the SolutionInn App