Lorenzo, the owner of a local poster shop, comes to you for help. While his shop...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lorenzo, the owner of a local poster shop, comes to you for help. While his shop has been breaking even for the past two years, it has not been able to generate a profit. For him to keep the shop open, he needs to earn at least $12,000 in operating income next year. You agree to help Lorenzo and ask him for some current information about his products' selling price and costs. You tell him you will work through some possible scenarios that might involve changing his sales price to generate the number of units sold needed to reach his target profit. Lorenzo shares the following information with you as you ponder different scenarios to help your client. Selling price Cost for paper, per unit Cost for printing, per unit Cost for film, per unit Staff salaries Other operating costs $7.50 $0.70 $1.10 $0.60 $48,000.00 $12,120.00 Using Lorenzo's data and proper Excel formulas, first, plan to get an understanding of Lorenzo's financial situation based on breakeven. Then look at the following five pricing scenarios: 1. Lower the selling price by 10% to increase sales volume by 5%. 2. Advertise on radio and social media for a combined cost of $1,000 to increase volume by 10%. 3. Use a more affordable paper on which to print the posters (available for $0.60 per unit), in combination with a less-expensive film to coat the surface of the poster (available for $0.40 per unit). 4. Instead of paying the salespeople a fixed salary, move to a commission-based compensation plan (save $20,000 in salary; incur $1.50 per unit sold commission), which should increase sales volume by 20%. 5. Advertise on radio and social media for a combined cost of $1,000 and, instead of paying salespeople a fixed salary, move to a commission-based compensation plan (save $20,000 in salary; incur $1.50 per unit sold commission), which could increase sales volume by 25%. A few days later, Lorenzo calls back and says he realizes he didn't take into account any tax consequences. He lets you know that he estimates his tax rate to be about 25% and asks if you could please factor that into the various options. He is open to raising the price of his posters if you think that is a viable option. He also lets you know that he's been approached by a potential client inquiring about a special order, and he wants you to advise him on whether to accept the order. The client wants 500 custom posters for $7 per poster. The posters will require a different type of paper that will cost $0.10 more per poster. The order will also require Lorenzo to pay an extra $1000 in employee costs. Per Lorenzo's request, you also decide to see what effect a price increase might have on Lorenzo's position. You have noticed that Lorenzo's is one of the only poster shops in the area, and customers may be willing to pay more, and a higher price may even signal higher quality. Though, there are no guarantees that the market will accept the price increase. Lorenzo is looking at a price increase of 15.7%, making the sales price $9.25. You let Lorenzo know that you will do an analysis of all options and present your recommendations when you are done. Lorenzo, the owner of a local poster shop, comes to you for help. While his shop has been breaking even for the past two years, it has not been able to generate a profit. For him to keep the shop open, he needs to earn at least $12,000 in operating income next year. You agree to help Lorenzo and ask him for some current information about his products' selling price and costs. You tell him you will work through some possible scenarios that might involve changing his sales price to generate the number of units sold needed to reach his target profit. Lorenzo shares the following information with you as you ponder different scenarios to help your client. Selling price Cost for paper, per unit Cost for printing, per unit Cost for film, per unit Staff salaries Other operating costs $7.50 $0.70 $1.10 $0.60 $48,000.00 $12,120.00 Using Lorenzo's data and proper Excel formulas, first, plan to get an understanding of Lorenzo's financial situation based on breakeven. Then look at the following five pricing scenarios: 1. Lower the selling price by 10% to increase sales volume by 5%. 2. Advertise on radio and social media for a combined cost of $1,000 to increase volume by 10%. 3. Use a more affordable paper on which to print the posters (available for $0.60 per unit), in combination with a less-expensive film to coat the surface of the poster (available for $0.40 per unit). 4. Instead of paying the salespeople a fixed salary, move to a commission-based compensation plan (save $20,000 in salary; incur $1.50 per unit sold commission), which should increase sales volume by 20%. 5. Advertise on radio and social media for a combined cost of $1,000 and, instead of paying salespeople a fixed salary, move to a commission-based compensation plan (save $20,000 in salary; incur $1.50 per unit sold commission), which could increase sales volume by 25%. A few days later, Lorenzo calls back and says he realizes he didn't take into account any tax consequences. He lets you know that he estimates his tax rate to be about 25% and asks if you could please factor that into the various options. He is open to raising the price of his posters if you think that is a viable option. He also lets you know that he's been approached by a potential client inquiring about a special order, and he wants you to advise him on whether to accept the order. The client wants 500 custom posters for $7 per poster. The posters will require a different type of paper that will cost $0.10 more per poster. The order will also require Lorenzo to pay an extra $1000 in employee costs. Per Lorenzo's request, you also decide to see what effect a price increase might have on Lorenzo's position. You have noticed that Lorenzo's is one of the only poster shops in the area, and customers may be willing to pay more, and a higher price may even signal higher quality. Though, there are no guarantees that the market will accept the price increase. Lorenzo is looking at a price increase of 15.7%, making the sales price $9.25. You let Lorenzo know that you will do an analysis of all options and present your recommendations when you are done.
Expert Answer:
Answer rating: 100% (QA)
To analyze Lorenzos financial situation and evaluate the different pricing scenarios lets start with the breakeven analysis based on the given information Breakeven Analysis First we calculate the bre... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Genevieve Shannara has always wanted to open her own kennel and grooming services; she had been grooming pets for friends and family from her apartment for extra cash since high school. When the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Wilburton Hospital is investigating the possibility of investing in new dialysis equipment. Two local manufacturers of this equipment are being considered as sources of the equipment. After-tax cash...
-
What are the pros, cons, and risks associated with Nikes core marketing strategy?
-
Working with a group of three or four students, collect at least five different job descriptions from organizations in your area. Compare the descriptions, highlighting similarities and differences.
-
Refer to the information in Exercise 16-14. Prepare journal entries dated June 30 to record: (a) raw materials purchases, (b) direct materials usage, (c) indirect materials usage, (d) direct labor...
-
The comparative balance sheet of Flack Inc. for December 31, 2013 and 2012, is shown as follows: The following additional information was taken from the records: a. The investments were sold for...
-
Explain why if assets are valuable resources and asset accounts have debit balances why do expense accounts also have debit balances. What is meant by the normal balance?
-
Obtain v(t) and i(t) for t > 0 in the circuit in Fig. 16.54 . 5 H ll i(t) 24 V (+ 10u(t) v(t) 200 mF
-
Write structures for the carbonyl electrophile and enolate nucleophile that react to give the aldo OH Write structures for the carbonyl electrophile and enolate nucleophile that react to give the al...
-
Jim is a pharmacist who works for a pharmacy chain in a large city. Jim developed a business that illegally solicited bets on sporting events. He promoted this to patients, and several patients would...
-
The board of pharmacy can take action against a licensee only when the licensee has been given notice of the action and an opportunity to explain the licensees side of the story at some sort of...
-
A dozen eggs cost $0.88 in January 1980 and $1.77 in January 2018. The average hourly wage for production and nonsupervisory workers was $6.57 in January 1980 and $22.36 in January 2018. a. By what...
-
This case actually incorporates several issues. The defendants in this case are Littles Pharmacy and its owner, James Little. The DEA conducted an audit of the pharmacy and determined that there were...
-
The PTRA facilitated the marketing of generic drugs by allowing generic drug sponsors to file ANDAs rather than NDAs. This case provides additional insight into the procedures followed by the FDA to...
-
PYTHON : mean, median, mode, and standard deviation WITHOUT using the stats module, develop an algorithm tocalculate the following: Create a program where : User inputs real numbers until an exit...
-
To balance the chemical equation SiH3 + O2 SiO2 + HO, you could introduce coefficients a, b, c, d and write aSiH3 + bO2 cSiO + dHO then write linear equations for each element. The equation for Si...
-
A grapefruit farmer in central Florida is trying to decide whether to take protective action to limit damage to his crop in the event that the overnight temperature falls to a level well below...
-
A technical note in the discussion of @RISK indicated that Latin Hypercube sampling is more efficient than Monte Carlo sampling. This problem allows you to see what this means. The file S15_44.xlsx...
-
The human resources manager of DataCom, Inc., wants to predict the annual salaries of given employees using the potential explanatory variables in the file P10_05.xlsx. a. Estimate an appropriate...
-
Gross profit is (A) Excess of sales over cost of goods sold (B) Sales less purchases (C) Cost of goods sold + opening inventory (D) Net profit less expenses of the period
-
To find the value of closing inventory at the end of a period we (A) Do this by physically counting the inventory (i.e. stocktaking) (B) Look in the inventory account (C) Deduct opening inventory...
-
Net profit is calculated in the (A) Trading account (B) Profit and loss account (C) Trial balance (D) Statement of financial position
Study smarter with the SolutionInn App