Question

Question #3: The manager of Walmart's in Arkansas is considering the possibility of providing flower delivery...

Question #3: The manager of Walmart's in Arkansas is considering the possibility of providing flower delivery service. She hires you as consultant for this project. You suggested that Walmart should do some marketing research to understand the market needs. Walmart has conducted a survey, the major findings include: The estimated number of customers is 400. An average customer is willing to buy $30 worth of flowers per order and pay $5 for delivery. An average customer tends to place 10 flower orders per year. To ensure on-time delivery Walmart's needs to invest $30,000 on a new van, which will be straight line depreciated over 10 years with $0 salvage value. The expenses of gas, repair, maintenance, and other operating costs incurred by this van will be $2,000 a year. Staff compensation will cost $50,000 a year. Advertising, promotion and other sales expenses will cost $10,000 a year. The average variable cost of flowers is 60% of the flower sales. There is no variable cost assigned to delivery. Please answer the following questions: What is unit contribution (per customer per year)? (2) What is BEV in each year? (2)

Homework Answers

Answer #1

1.

Unit contribution = Total contribution / Number of customers

Unit contribution = $56,000 / 400 = $140

2.

Break even value = Total fixed cost / contribution ratio

Contribution ratio = $56,000/140,000*100 = 40%

Break even value = $65,000 / 40% = $162,500

Working notes:

Sales revenue (400*$35*10) $140,000
Less: Variable cost ($140,000*60%) (84,000)
Contribution 56,000
Less: Fixed cost:
Depreciation on van ($30,000/10) $3,000
Gas, repair, maintenance and other cost 2,000
Staff compensation 50,000
Advertising,promotion and other sales expenses 10,000
Total fixed cost (65,000)
Net loss $(9,000)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question #3: The manager of Walmart's in Arkansas is considering the possibility of providing flower delivery...
Question #3: The manager of Walmart's in Arkansas is considering the possibility of providing flower delivery service. She hires you as consultant for this project. You suggested that Walmart should do some marketing research to understand the market needs. Walmart has conducted a survey, the major findings include: The estimated number of customers is 400. An average customer is willing to buy $30 worth of flowers per order and pay $5 for delivery. An average customer tends to place 10...
1.Suppose you are running your own flower delivery business (called Here Comes the Bloom) and have...
1.Suppose you are running your own flower delivery business (called Here Comes the Bloom) and have the following financial information (per year): total revenues from sales are $260,000, labor costs are $85,000, rent is $20,000, materials are $33,000, vehicle related costs (fuel, insurance, maintenance) are $10,000 and utilities are $7,000. You own the delivery van and could rent it out for $6,000 per year if you weren’t using it to run your own business. You have a standing offer to...
After returning home, you were interested in finding out your customer lifetime value so that you...
After returning home, you were interested in finding out your customer lifetime value so that you could develop promotional campaigns to improve your CLV. In order to calculate the CLV metric, a speaker at the marketing conference suggested that you use data from your company's books related to four variables. The first variable is average value of sales per year. Your books showed that on average, the average value of sales per year was $750. The second variable is average...
David is a product manager at HP (Nebraska), and in charge of printers and related accessories....
David is a product manager at HP (Nebraska), and in charge of printers and related accessories. After reviewing his sales figures for the past third quarter, David is worried that he might not hit this year’s annual sales targets. As a consequence, he considers an end-of-year promotion in cooperation with selected retailers in Nebraska. David has been approached by Samantha, owner and managing director of Direct2U, a direct marketing firm in Omaha. Samantha has offered her services in developing and...
Real World Case 3-7 (Static) Balance sheet and significant accounting policies disclosure; Walmart [LO3-2, 3-3, 3-4,...
Real World Case 3-7 (Static) Balance sheet and significant accounting policies disclosure; Walmart [LO3-2, 3-3, 3-4, 3-8] The balance sheet and disclosure of significant accounting policies taken from the 2017 annual report of Walmart Stores Inc. appear below. Use this information to answer the following questions: WAL-MART STORES, INC. Consolidated Balance Sheets ($ in millions except per share data) As of January 31, 2017 2016 Assets Current assets: Cash and cash equivalents $ 6,867 $ 8,705 Receivables (net) 5,835 5,624...
Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze...
Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze casting line to its production facility. Over the past several years the artistic community in Park City and along the Wasatch front has significantly increased and the company has received an increasing number of requests to do bronze castings. The casting line would be set up in unused space in Gilroy’s main plant. The equipment would cost approximately $200,000, plus another $10,000 for shipping...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze casting line to its production facility. Over the past several years the artistic community in Park City and along the Wasatch front has significantly increased and the company has received an increasing number of requests to do bronze castings. The casting line would be set up in unused space in Gilroy’s main plant. The equipment would cost approximately $200,000, plus another...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze casting line to its production facility. Over the past several years the artistic community in Park City and along the Wasatch front has significantly increased and the company has received an increasing number of requests to do bronze castings. The casting line would be set up in unused space in Gilroy’s main plant. The equipment would cost approximately $200,000, plus another...
Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company...
Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers all of its manufacturing overhead costs to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Koontz’s controller prepared the segmented income statement that is shown below for the most recent year (he allocated selling and administrative expenses to products based on sales dollars):     Basic      Advanced      Total Number of units produced and sold      20,000  ...
Integration Exercise 6 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 2-1, LO...
Integration Exercise 6 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 2-1, LO 2-2, LO 2-3, LO 2-4, LO 6-4, LO 6-5, LO 7-1, LO 7-3, LO 7-4] Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers all of its manufacturing overhead costs to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Koontz’s controller prepared the segmented income statement that is shown below...