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 new tornado-resistant communications tower is being planned for the area around Regina. The area averages 3.25 tornadoes per year. Find the probability that in a one-year period, the number of...
-
Tom and John go to an island to fish and then bring to the market to sell. They are the only people to sell finish in the market which has the following demand: P = 100 - Q, where P is the price and...
-
One of Gold Empire Ltds four departments has reported a loss of $80000 after deducting $204000 of expenses. Assume that only $130000 of the expenses can be eliminated if the department is...
-
On July 15, Mann Company sold $600,000 in accounts receivable for cash of $500,000. The factor withheld 10% of the cash proceeds to allow for possible customer returns or account adjustments. An...
-
Golden State Elixirs' tinctures are produced in four steps: extraction, blending, testing, and bottling. The first step is the extraction of cannabis oil from cannabis buds, also called cannabis...
-
How might one employee coach or train another employee by use of Twitter and text messaging?
-
At age 18, someone sets up an IRA (individual retirement account) with an APR of 8%. At the end of each month he deposits $55 in the account. How much will the IRA contain when he retires at age 65?...
-
Walmart is the worlds largest company by revenue and is the worlds top retailer with more than 2.3 million employees. In the United States, Walmart operates more than 5,300 stores, including about...
-
In 1998, Daimler-Benz bought 100% of Chrysler Corp. for $36 billion. In 2007, DaimlerChrysler announced it was selling 80.1% percent of Chrysler to the private-equity firm Cerberus Capital Management...
-
Can you think of situations where someone might violate the code of ethics in a company but should not be punished for it? Give examples.
-
Which of the three quantitative forecasting methods do you think would give you the most accurate forecast? Explain your choice.
-
Soviet Services has a five-year maximum acceptable payback period. The firm is considering purchasing a new washing machine and must choose between two alternatives. The first machine, IntelWash,...
-
One of Swifty Company's activity cost pools is inspection which has estimated overhead costs of $150000. Swifty produces throw rugs (700 inspections) and area rugs (1300 inspections). what amount of...
-
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 number on the jersey of each New York Giants football player is recorded, then the mean of those numbers is computed. Decide whether the statement makes sense (or is clearly true) or does not...
-
A professor calculates final grades using a weighted mean in which the final exam counts twice as much as the midterm. Decide whether the statement makes sense (or is clearly true) or does not make...
-
The following ages (years) of survey respondents: 22, 19, 21, 27, over 65, over 80. State whether the mean or median would give a better description of the average. Explain your reasoning.
Study smarter with the SolutionInn App