Question;MBA 6100;Fall 2014, Block 1;Case Study #1;Students are to submit one Excel file for this case with each problem;on a unique worksheet. All calculations must be clearly indicated/articulated;in your case preparation. You also must utilize formula functions where;appropriate.;Problem #1 ? DPN Health Systems ? CVP Analysis;DPN Health Systems operates a general hospital in;southern Delaware. The medical center also rents space and beds to separately;owned entities rendering specialized services, such as Stroke Rehabilitation;and Psychiatric Care. DPN charges each separate entity for common services;such as patients? meals and laundry, and for administrative services such as;billings and collections. Space and bed rental are fixed charges each year, based;on bed capacity rented to each entity. DPN Health Systems charged the following;costs to Stroke Rehabilitation for the year ended December 31, 2013;Patient days;Bed Capacity;(Variable);(Fixed);Dietary;$;700,000;Janitorial;-;$;80,000;Laundry;340,000;-;Laboratory;560,000;-;Pharmacy;400,000;-;Repairs and maintenance;-;35,000;General and administrative;-;1,420,000;Rent;-;1,750,000;Billings and collections;300,000;-;Total;$;2,300,000;$;3,285,000;During the year;ended December 31, 2013, Stroke Rehab charged each patient an average of $375;per day, had a capacity of 60 beds, and had revenue of $7.0 million for 365;days. In addition, Stroke Rehab directly employed personnel with the following;annual salary costs per employee: supervising nurses, $32,000, nurses, $23,500;and aides, $12,000.;DPN has the following minimum departmental;personnel requirements based on total annual budgeted patient days;Supervising;Annual;Patient-days;Nurses;Nurses;Aides;Up to 22,000;4;10;20;22,001 to 26,000;5;14;25;26,001 to 29,000;5;16;31;Stroke Rehab always;employes only the minimum number of required personnel. Salaries of supervising;nurses, nurses, and aides are therefore fixed within ranges of annual patient-days.;Stroke Rehab operated at 100% capacity on 90 days;during the year ended December 31, 2013. Administrators estimate that on these;90 days, Stroke Rehab could have filled another 20 beds above capacity. DPN has;an additional 20 beds available for rent for the year ending December 31, 2014.;Such;additional rental;would increase Stroke Rehab?s fixed charges based on bed capacity. (In the;following requirements, ignore income taxes).;Required;Calculate the;minimum number of patient-days required for Stroke Rehab to break even for;the year ending December 31, 2014, if the additional 20 beds are not;rented. Patient demand is unknown, but assume that revenue per;patient-day, cost per patient-day, cost per bed, and salary rates will;remain the same as for the year ended December 31, 2013.;Assume that;patient demand, revenue per patient-day, cost per patient-day, cost per;bed, and salary rates for the year ending December 31, 2014, remain the;same as for the year ended December 31, 2013. Prepare a schedule of Stroke;Rehab?s increase in revenue and increase in costs for the year ending;December 31, 2014. Determine the net increase or decrease in Stroke;Rehab?s earnings;from the additional 20 beds if Stroke Rehab rents this extra capacity from DPN;Health Systems.;Should Stroke Rehab rent the extra capacity?;Problem #2 ? Willer Company ? Product Costing;Willer Company is a;small computer component manufacturer. Several years ago, the company decided;to concentrate on only three models, which were sold under many brand names to;electronics retailers and mass-market discount stores. For internal purposes;the company uses the product names Sonic, Rapid, and Lightning to refer to the;three components.;The President of the company has issued the;following memo;I don?t understand this. In 2012, we decided to;drop our highest-end Sonic model and only produce the Rapid and Lightning;models, because our cost system indicated we were losing money on Sonic. Now;looking at preliminary numbers, our profit is actually lower than last year and;it looks like Rapid has become a money loser, even though our prices, volumes;and direct costs are the same. Can someone please explain this to me and maybe;help me decide what to do next year?;Data on the three models and selected costs;follow;For the year ended December 31, 2012;Sonic;Rapid;Lightning;Total;Units produced and sold;6,000;11,000;19,000;36,000;Sales price per unit;$;140.00;$;115.00;$;65.00;Direct materials cost per unit;$;75.00;$;60.00;$;25.00;Direct labor-hours per unit;2.5;1.5;1.0;Wage rate per hour;$;21.00;$;21.00;$;21.00;Total manufacturing overhead;$;700,000;For 2013, the;company only produced the Rapid and Lightning models. Total overhead was $625,000.;All other volume, unit prices, costs, and direct labor usage were the same as;in 2012. The product cost system at Willer Products allocates manufacturing;overhead based on direct labor hours.;Required;Compute the product cost and gross;margins (revenue less cost of goods sold) for the three products and total;gross profit for 2012. (Round your numbers to 2 decimal places);Compute the product cost and gross;margins (revenue less cost of goods sold) for the two products and total;gross profit for 2013. (Round your numbers to 2 decimal places)3.;Should;Willer drop Rapid for year 3? Explain (your explanation must include a;numerical analysis to support your position).;Hint: Total manufacturing overhead above includes both fixed and variable;costs. Use the high-low method to separate the Total Manufacturing Overhead;into variable and fixed costs and then analyze the Rapid model using;contribution margin analysis. I will give 2 points extra credit to anyone who;can explain how we know the manufacturing overhead includes both fixed and;variable costs.
Paper#54226 | Written in 18-Jul-2015Price : $33