CollegeMix: Payback Constraint with Sensitivity Analysis A Daniels marketing grad took a job at a vitamin...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
CollegeMix: Payback Constraint with Sensitivity Analysis A Daniels marketing grad took a job at a vitamin company, VHealth, and came up with a great new product idea. The idea is to create a vitamin blend targeted towards the needs of college students, to be called "CollegeMix." VHealth would'sell CollegeMix through a chain of retailers. VHealth has a corporate policy that new product ideas must achieve payback in two years. CollegeMix details: Package design: $3,000 Vitamin materials per bottle: $4 Bottle cost: .25 each Bottle filling, labeling, boxing: .25 each Fee for selling into distribution channel: $15,000 Stocking/slotting fee: $100,000 Suggested price on shelf: $11.00 Price that VHealth would charge retailer: $9.50 1) How many units per month would they have to sell in order to achieve break-even in two years? 2) Offer a sensitivity analysis to show what the profit would look like at the end of two years at the following sales levels: 500 units per month 800 units per month 1000 units per month month 1200 units per 1500 units per month. Show your answer on one page and include print outs of your Excel work as appendices, following "Presenting Analyses in Writing." CollegeMix: Payback Constraint with Sensitivity Analysis A Daniels marketing grad took a job at a vitamin company, VHealth, and came up with a great new product idea. The idea is to create a vitamin blend targeted towards the needs of college students, to be called "CollegeMix." VHealth would'sell CollegeMix through a chain of retailers. VHealth has a corporate policy that new product ideas must achieve payback in two years. CollegeMix details: Package design: $3,000 Vitamin materials per bottle: $4 Bottle cost: .25 each Bottle filling, labeling, boxing: .25 each Fee for selling into distribution channel: $15,000 Stocking/slotting fee: $100,000 Suggested price on shelf: $11.00 Price that VHealth would charge retailer: $9.50 1) How many units per month would they have to sell in order to achieve break-even in two years? 2) Offer a sensitivity analysis to show what the profit would look like at the end of two years at the following sales levels: 500 units per month 800 units per month 1000 units per month month 1200 units per 1500 units per month. Show your answer on one page and include print outs of your Excel work as appendices, following "Presenting Analyses in Writing."
Expert Answer:
Answer rating: 100% (QA)
BreakEven Point is a situation where if Breakeven Units are ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
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...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
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...
-
Consider a scenario, in which there were four students (Arthur, Kevin, Morris, and Orlando) driving their cars back home from Houston. However, only Orlando was involved in a car accident. We want to...
-
How can a manger evaluate the effectiveness of the maintenance function?
-
You are planning the audit of the PageDoc Company's inventory. PageDoc manufactures a variety of office equipment. Required Describe how each of the following procedures could be used in the audit of...
-
Wendy Craven is the sole shareholder of a property management company near the campus of Pensacola Junior College. The business has cash of \($6,000\) and furniture that cost \($12,000\) and has a...
-
Correct and complete the following cites: a. R.R. 95-20, 1 CB. 163 b. Rev. Ruling 91-14, 1991 CB 18 c. Rev. Rul. 72-604 d. Rev. Rul. 57-441, 1957-50 IRB 2 e. R.P. 2003-19 f. Rev. Procedure 96-1,...
-
Anita Fields purchased 50 bonds of ABC company at the close. Find the total cost and annual interest. Assume a commission of $6 per bond. Company (Ticker) Coupon Last Last EST $ VOL Company ABC 1.940...
-
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: The same raw material is used in all three...
-
These are the four questions in the end of this case. please give answers to these 4 questions. >> ALEXA. Are you listening to me? Seewhatmitchsee-Shutterstock In April 2019, news site Bloomberg...
-
The following is the adjusted trial balance of Sierra Company. Sierra Company Adjusted Trial Balance Account Title Cash December 31 Prepaid insurance Notes receivable (due in 5 years) Buildings...
-
Given two randomly ordered integer arrays A and B each of n integer numbers. Consider the following function: bool Quiz (int A[0..n-1 ], int B[0..n-1 ], int n) { } int k = 0; for (i =0; i
-
Find the quotient & remainder using synthetic division. x323x-13 x = 5 The quotient is The remainder is
-
Given Information Initial Investment = $ 1 , 0 0 0 , 0 0 0 WACC = 1 0 % Revenue = $ 8 5 0 , 0 0 0 COGS = $ 5 4 0 , 0 0 0 Operating Expenses = $ 5 0 , 0 0 0 Depreciation Expense = $ 1 2 5 , 0 0 0 Tax...
-
KLM Company issued $ 3 million of 9 . 7 5 % $ 8 0 par preferred shares in 2 0 0 1 . Calculate the total amount of dividends paid on this issue per year and the annual amount of the dividends per...
-
2. Assume a panel model with individual random effects and fixed time ef- fects: Yit Uit = XB+At+Uit, fi +Vit. (a) Its BLUE estimator can be written in the form (C'N-C)-C'Ny. Give a short description...
-
Juanita owns a home in Richardson, TX. She purchases a Homeowners Policy (HO-3) from Farm State Ins. Co. The policy provides $100,000 in liability coverage (coverage E) and $5,000 in Med Pay coverage...
-
Original activity-based costing, activity-based management (Adapted from CMA, June 1992) Alaire Corporation manufactures several different types of printed-circuit boards; however, two of the boards...
-
Service department cost allocation, direct method San Rafael Company has two production departments, assembly and finishing, and two service departments, machine setup and inspection. Machine setup...
-
Compute activity-based cost rate, time equations CAN Company sells multiple products and uses a time-driven ABC system. The companys products must be wrapped individually before shipping. The...
-
Optimize the following Boolean functions \(F\) together with the don't-care conditions \(d\) : (a) \(F(A, B, C, D)=\Sigma m(0,1,7,13,15), d(A, B, C, D)=\Sigma m(2,6,8,9,10)\) (b) \(F(W, X, Y,...
-
+Apply the simplified Espresso algorithm to the following function. Show a K-map for each algorithm routine that changes one or more implicants. \[F(A, B, C, D)=\bar{A} \bar{B} \bar{D}+\bar{B}...
-
Illustrate the expansion or reduction performed on each implicant on a Kmap if the operation changes the implicant. (a) Apply the Espresso EXPAND routine to the following function. \[F(A, B, C,...
Study smarter with the SolutionInn App