Affordable Office Supplies Affordable Office Supplies is a discount office supply store. They maintain that they...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Affordable Office Supplies Affordable Office Supplies is a discount office supply store. They maintain that they have the lowest prices in the metropolitan area for office equipment, furniture and supplies. The manager, Ms. Ruth Less, has decided to engage you to evaluate the profitability of each of her five departments: Average Selling Price $250 125 Departments Furniture Equipment Computer Supplies Paper Supplies Miscellaneous 20 30 15 Ms. Less informs you that historically each of these departments has represented a certain percentage of sales dollars: Percentage Sales Dollars Items Building Depreciation Utilities Salaries Departments Furniture Equipment Computer Supplies Paper Supplies Miscellaneous The fixed costs for Affordable Office Supplies are as follows: Amount $20,000 Average Variable Costs $175 65 12 22 10 25% 20% 15% 25% 15% Equipment Depreciation Furniture Depreciation Miscellaneous Total 13,000 180,000 6,000 2,500 2,500 $224,000 Ms. Less wants you to assist her in evaluating the following: (1)Determine the breakeven in dollars for each department. (2)Evaluate the different departments and rank them by profitability and amount of total contribution. What would you recommend to Ms. Less? (3) Given the following information: Departments Furniture Square Footage 7,000 6,000 2,000 Equipment Computer Supplies Paper Supplies Miscellaneous 3,000 2.000 20,000 Total Determine which department has the best contribution per square foot. Would this modify your answer in (2)? What would you recommend now? Murray Mobile, the owner of Murray's Car Rental, (MCR) is concerned about his rental car business. He believes that he could improve the profitability of his business if he rented his cars at the lowest price. He has asked you. as a knowledgeable accounting student at UVI to assist him in his assessment. MCR rents only Toyota models. They rents the Tercel, Corolla, Cellica and Camry. Murray received some statistical information from the NARCA (National Association of Rental Car Agents): Corolla Cellica Camry' Frequency of Rental (%) $25 $30 $35 $40 $45 $50 $55 100 85 60 20 100 90 80 75 60 40 30 100 100 100 90 80 60 40 100 100 100 100 90 80 60 Model Tercel Corolla Cellica Camry Note: This rental frequency is based on 90% of theoretical availability. Murray also knows what the variable cost and purchase price of each model: Variable Costs Model (per rental day) Tercel $10 12 14 15 Murray's Car Rental Rent Royalty Fees Utilities Salaries Note: Vehicles are usually depreciated straight-line over the five year life of the vehicle. Murray estimates that his total fixed costs per year are as follows: Office Supplies Misc. $30,000 10,000 10,000 37,000 5,000 5,000 $97,000 Purchase Price $8,000 10,000 15,000 20,000 Murray wants you to assist him in determining the following: (1) What is breakeven in units of each model given the following mix and pricing structure (don't forget depreciation) Model Tercel Corolla Cellica Camry # of Vehicles 10 10 5 5 Rental Fee (per day) $25 $30 $35 $40 (2) What would be the optimum pricing structure given the number of vehicles in (1)? (3) If Murray had $500,000 to buy new vehicles, what would you advise him to buy and why? Affordable Office Supplies Affordable Office Supplies is a discount office supply store. They maintain that they have the lowest prices in the metropolitan area for office equipment, furniture and supplies. The manager, Ms. Ruth Less, has decided to engage you to evaluate the profitability of each of her five departments: Average Selling Price $250 125 Departments Furniture Equipment Computer Supplies Paper Supplies Miscellaneous 20 30 15 Ms. Less informs you that historically each of these departments has represented a certain percentage of sales dollars: Percentage Sales Dollars Items Building Depreciation Utilities Salaries Departments Furniture Equipment Computer Supplies Paper Supplies Miscellaneous The fixed costs for Affordable Office Supplies are as follows: Amount $20,000 Average Variable Costs $175 65 12 22 10 25% 20% 15% 25% 15% Equipment Depreciation Furniture Depreciation Miscellaneous Total 13,000 180,000 6,000 2,500 2,500 $224,000 Ms. Less wants you to assist her in evaluating the following: (1)Determine the breakeven in dollars for each department. (2)Evaluate the different departments and rank them by profitability and amount of total contribution. What would you recommend to Ms. Less? (3) Given the following information: Departments Furniture Square Footage 7,000 6,000 2,000 Equipment Computer Supplies Paper Supplies Miscellaneous 3,000 2.000 20,000 Total Determine which department has the best contribution per square foot. Would this modify your answer in (2)? What would you recommend now? Murray Mobile, the owner of Murray's Car Rental, (MCR) is concerned about his rental car business. He believes that he could improve the profitability of his business if he rented his cars at the lowest price. He has asked you. as a knowledgeable accounting student at UVI to assist him in his assessment. MCR rents only Toyota models. They rents the Tercel, Corolla, Cellica and Camry. Murray received some statistical information from the NARCA (National Association of Rental Car Agents): Corolla Cellica Camry' Frequency of Rental (%) $25 $30 $35 $40 $45 $50 $55 100 85 60 20 100 90 80 75 60 40 30 100 100 100 90 80 60 40 100 100 100 100 90 80 60 Model Tercel Corolla Cellica Camry Note: This rental frequency is based on 90% of theoretical availability. Murray also knows what the variable cost and purchase price of each model: Variable Costs Model (per rental day) Tercel $10 12 14 15 Murray's Car Rental Rent Royalty Fees Utilities Salaries Note: Vehicles are usually depreciated straight-line over the five year life of the vehicle. Murray estimates that his total fixed costs per year are as follows: Office Supplies Misc. $30,000 10,000 10,000 37,000 5,000 5,000 $97,000 Purchase Price $8,000 10,000 15,000 20,000 Murray wants you to assist him in determining the following: (1) What is breakeven in units of each model given the following mix and pricing structure (don't forget depreciation) Model Tercel Corolla Cellica Camry # of Vehicles 10 10 5 5 Rental Fee (per day) $25 $30 $35 $40 (2) What would be the optimum pricing structure given the number of vehicles in (1)? (3) If Murray had $500,000 to buy new vehicles, what would you advise him to buy and why?
Expert Answer:
Answer rating: 100% (QA)
1 The breakeven point for each department can be calculated using the following formula Breakeven po... View the full answer
Related Book For
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these accounting questions
-
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...
-
Mr. Burns, president of Greetings Inc., created the Wall Décor unit of Greetings three years ago to increase the company's revenue and profits. Unfortunately, even though Wall Décor's...
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
Discuss documents that need to be included in recovery documentation?
-
The records of Lindbergh Aviation include the following accounts for inventory of aviation fuel at July 31 of the current year: Requirements 1. Prepare a partial income statement through gross profit...
-
Separate company financial statements for Pop Corporation and its subsidiary, Son Company, at and for the year ended December 31, 2017, are summarized as follows (in thousands): Additional...
-
Discuss the benefi ts of hiring an outside interim chief executive. What are the pros and cons of a board member acting as the interim chief executive?
-
Pierce Furnishings generated $2 million in sales during 2008, and its year-end total assets were $1.5 million. Also, at year-end 2008, current liabilities were $500,000, consisting of $200,000 of...
-
You are a manager at Squidwork, Inc., which is a lucrative online boutique ( e - commerce company ) that has gone through massive growth in a short amount of time. Over the past two years, there has...
-
You have estimated spot rates as follows: r1 = 5.00%, r2 = 5.40%, r3 = 5.70%, r4 = 5.90%, r5 = 6.00%. a. What are the discount factors for each date (that is, the present value of $1 paid in year t)?...
-
In view of settlement risk and increasing interest rates, explain the following: a . What is Herstatt risk? b . How Assets and Liabilities are considered Rate Sensitive?
-
In the figure a "semi-infinite" nonconducting rod (that is, infinite in one direction only) has uniform linear charge density = 5.19 C/m. Find (including sign) (a) the component of electric field...
-
how your choices affect your community and environment. Explain what actions you do daily that can have long - term effects. List ways you could reduce waste and preserve resources in your daily life.
-
Consider the class hierarchy shown to the right. Each class in the hierarchy will have the following constructor and overridden toString() method, where X is replaced with the class name. public X()...
-
9. Construction sand is piled in a right cone that has a height of 30 feet and a diameter of 110 feet. The sand has a density of 98.0 lb/ft. a) Determine the volume of the cone to the nearest 0.1 ft....
-
How was Pepsi able to come back from near bankruptcy and gain share at the expense of Coke from the 19505 through to 1975?
-
Forausteniticstainlesssteel,Cu,andAl(allFCCmetals): a. Calculate the actual magnitudes of the full and partial dislocations, assuming that the lattice parameters are 0.365 nm, 0.362 nm, and 0.405 nm,...
-
What is the amount of total interest dollars earned on a $5,000 deposit earning 6% for 20 years?
-
In the practice of public accounting, an auditor who is a member of the AICPA is expected to comply with the rules of the AICPA Code of Professional Conduct. Listed below are circumstances that raise...
-
a. Gather information: As MSI is looking for someone to fill the vacant board position, what requirements must be followed? What characteristics or qualities would be ideal for the board member to...
-
Identify two analytical techniques that could be used as part of risk assessment ADA and how they could be useful.
-
Arich uncle allows you to stipulate which of two ways you receive your inheritance: a. \($850,000\) one year after his death or b. \($250,000\) on his death and \($200,000\) each year at the end of...
-
You have the right to receive \($30,000\) at the end of each of the next four years, and money is worth 8%. Using the PV tables, your financial calculator, or Excel, compute the present value of this...
-
Briefly describe the concept of the time value of money.
Study smarter with the SolutionInn App