Explore BrainMass
Share

Explore BrainMass

    Calculating the productivity ratios in the given case

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The Morning Brew Coffee Shop sells Regular, Cappuccino, and Vienna blends of coffee. The shop's current daily labor cost is $320, the equipment cost is $125, and the overhead cost is $225. Daily demands, along with selling price and material costs per beverage, are given below.

    Regular Coffee Cappuccino Vienna Coffee
    Beverages sold 350 100 150
    Price per beverage $2.00 $3.00 $4.00
    Material ($) $0.50 $0.75 $1.25

    Harald Luckerbauer, the manager at Morning Brew Coffee Shop, would like to understand how adding Eiskaffee (a German coffee beverage of chilled coffee, milk, sweetener, and vanilla ice cream) will alter the shop's productivity. His market research shows that Eiskaffee will bring in new customers and not cannibalize current demand. Assuming that the new equipment is purchased before Eiskaffee is added to the menu, Harald has developed new average daily demand and cost projections. The new equipment cost is $200, and the overhead cost is $350. Modified daily demands, as well as selling price and material costs per beverage for the new product line, are given below.

    Regular Coffee Cappuccino Vienna Coffee Eiskaffee
    Beverages sold 350 100 150 75
    Price per beverage $2.00 $3.00 $4.00 $5.00
    Material ($) $0.50 $0.75 $1.25 $1.50

    a. Calculate the change in labor and multifactor productivity if Eiskaffee is added to the menu.
    b. If everything else remains unchanged, how many units of Eiskaffee would have to be sold to ensure that the multifactor productivity increases from its current level?

    © BrainMass Inc. brainmass.com October 10, 2019, 5:21 am ad1c9bdddf
    https://brainmass.com/business/labour-management-and-relations/calculating-the-productivity-ratios-in-the-given-case-502019

    Attachments

    Solution Preview

    Please refer attached file for better clarity of tables in MS Excel.

    a. Calculate the change in labor and multifactor productivity if Eiskaffee is added to the menu.

    Case 1- Without Eiskaffee

    Regular Coffee Cappuccino Vienna Coffee Total
    Beverages Sold, Q 350 100 150
    Price per beverage, P 2 3 4
    Material ($), M 0.50 0.75 1.25
    Total Revenue, P*Q 700 300 600 1600
    Material Cost, M*Q 175.00 75.00 187.50 ...

    Solution Summary

    Productivity ratios help us to analyze the relationship between input and output costs. Solution to the given problem describes the steps to calculate labor and mutifactor productivity ratios with and without a new product called Eiskaffee. It also calculates the number of units of Eiskaffee that should be sold to ensure an increase in multifactor productivity ratio.

    $2.19