Quality Pretzels Inc. makes chocolate-covered pretzels and other snacks in its Waco plant. Its products are sold in 5-pound metal containers, which are also manufactured at the Waco plant. In June 2014, the plant manager, Sarah Cassidy, was approached by Texas Canister Company with an offer to supply the canisters at a price of S1 each. Quality Pretzels assigns the following direct costs to canister production, corresponding to a volume of 760,000 canisters Direct material Direct labor (12,000 hours at $15 per hour) $300,000 180,000 Both direct costs are considered variable. The company assigns variable overhead at $10 per direct labor hour and fixed manufacturing overhead at $45 per direct labor hour. Cassidy views this decision as a "long-term" decision because she expects that her fixed costs will decrease should she decide to accept the offer from Texas Canister Company. Assume that cost is the only consideration in her decision-making process (i.e., dimensions such as quality and delivery reliability are not relevant) Required 1. Based on the direct-labor-based product costing system in place, would Cassidy be inclined to accept the order? Show your computations 2. Never a fan of the direct-labor-based system, Cassidy performs her own analysis and determines that only S80,000 of supervisor salaries and $28,000 of machinery depreciation can be avoided from the fixed manufacturing overhead if she buys the canisters from Texas Canister Company. Based on this information, would Cassidy be inclined to accept the order? Show your computations 3. Meanwhile, the controller of Quality Pretzels, Dave Paxon, had performed an activity based costing analysis of Quality's overall cost structure. His analysis is captured in the following exhibit: Annual Budge ted cost Budgeted levels of cost drver unlt for the CapactyIn cost driver unlts Actlvity cost pool Cost driver 201 Facility le vel Plant depreciation Product-sustaining level Product development Supervisory salarles Batch level Material handling Purchasing Inspection Setup Unitlevel 51650,000 300,000 Product specs 600,000 Supervisory hours 15,000 15,000 800,000 Material-handling hours 250,000 #of Purchase orders 300,000 #Of Inspections 80,000 100,000 1000 1000 1000 ,000 # of setups Electricity Oll and lubrication Equipment maintenance Machinery depreclation Total overhead 700, 0 120,000 180,000 200.000 55,500,000 # of machine hours # of machine hours #of machine hours # of machine hours 450,000 450,000 450,000 450,000 500,000 500,000 500,000 500,000 Dave provides data both on capacity and on budgeted volume for 2014 because the volume in 2014 is unusually low, relative to a typical year in which capacity is used fully Going forward, there is every expectation that capacity will be utilized fully. Assume now that Sarah consults Dave about the decision. Moreover, after further analysis, she concludes that the cost driver levels associated with canister production are as follows: 10 product specs, 2,000 supervisory hours, 6,000 material-handling hours, 30 inspections, 15 setups, 55 purchase orders, and 70,000 machine hours. Based on this information, would Sarah make or buy? How much would she save for the company with her decision? Show your computations 4. Many skeptics argue that activity-based costing is just a fancy way of allocating fixed costs. In your opinion, under what conditions would activity-based costing systems provide useful and appropriate co planning decisions? st bases for long-term product planning and capacity Quality Pretzels Inc. makes chocolate-covered pretzels and other snacks in its Waco plant. Its products are sold in 5-pound metal containers, which are also manufactured at the Waco plant. In June 2014, the plant manager, Sarah Cassidy, was approached by Texas Canister Company with an offer to supply the canisters at a price of S1 each. Quality Pretzels assigns the following direct costs to canister production, corresponding to a volume of 760,000 canisters Direct material Direct labor (12,000 hours at $15 per hour) $300,000 180,000 Both direct costs are considered variable. The company assigns variable overhead at $10 per direct labor hour and fixed manufacturing overhead at $45 per direct labor hour. Cassidy views this decision as a "long-term" decision because she expects that her fixed costs will decrease should she decide to accept the offer from Texas Canister Company. Assume that cost is the only consideration in her decision-making process (i.e., dimensions such as quality and delivery reliability are not relevant) Required 1. Based on the direct-labor-based product costing system in place, would Cassidy be inclined to accept the order? Show your computations 2. Never a fan of the direct-labor-based system, Cassidy performs her own analysis and determines that only S80,000 of supervisor salaries and $28,000 of machinery depreciation can be avoided from the fixed manufacturing overhead if she buys the canisters from Texas Canister Company. Based on this information, would Cassidy be inclined to accept the order? Show your computations 3. Meanwhile, the controller of Quality Pretzels, Dave Paxon, had performed an activity based costing analysis of Quality's overall cost structure. His analysis is captured in the following exhibit: Annual Budge ted cost Budgeted levels of cost drver unlt for the CapactyIn cost driver unlts Actlvity cost pool Cost driver 201 Facility le vel Plant depreciation Product-sustaining level Product development Supervisory salarles Batch level Material handling Purchasing Inspection Setup Unitlevel 51650,000 300,000 Product specs 600,000 Supervisory hours 15,000 15,000 800,000 Material-handling hours 250,000 #of Purchase orders 300,000 #Of Inspections 80,000 100,000 1000 1000 1000 ,000 # of setups Electricity Oll and lubrication Equipment maintenance Machinery depreclation Total overhead 700, 0 120,000 180,000 200.000 55,500,000 # of machine hours # of machine hours #of machine hours # of machine hours 450,000 450,000 450,000 450,000 500,000 500,000 500,000 500,000 Dave provides data both on capacity and on budgeted volume for 2014 because the volume in 2014 is unusually low, relative to a typical year in which capacity is used fully Going forward, there is every expectation that capacity will be utilized fully. Assume now that Sarah consults Dave about the decision. Moreover, after further analysis, she concludes that the cost driver levels associated with canister production are as follows: 10 product specs, 2,000 supervisory hours, 6,000 material-handling hours, 30 inspections, 15 setups, 55 purchase orders, and 70,000 machine hours. Based on this information, would Sarah make or buy? How much would she save for the company with her decision? Show your computations 4. Many skeptics argue that activity-based costing is just a fancy way of allocating fixed costs. In your opinion, under what conditions would activity-based costing systems provide useful and appropriate co planning decisions? st bases for long-term product planning and capacity