Question: Supermart Food Stores ( SFS ) has experienced net operating losses in its frozen food products line in the last few periods. Management believes that
Supermart Food Stores SFS has experienced net operating losses in its frozen food products line in the last few periods. Management believes that the store can improve its profitability if SFS discontinues frozen foods. The operating results from the most recent period are:
Sales: Frozen Food $ Baked Goods $ Fresh Produce $
Cost of Goods Sold: Frozen Food $ Baked Goods $ Fresh Produce $
SFS estimates that store support expenses, in total, are approximately of revenues.
The controller says that not every sales dollar requires or uses the same amount of store support activities. A preliminary analysis reveals store support activities for these three product lines are:
Activity cost driver
Order processing number of purchase orders Frozen Foods Baked Goods Fresh Produce
Receiving number of deliveries Frozen Foods Baked Goods Fresh Produce
Shelf stocking number of hours per delivery Frozen Foods Baked Goods Fresh Produce
Customer support total units sold Frozen Foods Baked Goods Fresh Produce
The controller estimates activitycost rates for each activity as follows:
Order processing $ per purchase order
Receiving $ per delivery
Shelf stocking $ per hour
Customer support $ per item
Prepare a productline profitability report for SFS under the current costing system.
Note: Lossamounts should be indicated by a minus sign. Round operating margin loss to decimal places ie should be entered as
Prepare a productline profitability report for SFS using the ABC information the controller provides.
Note: Loss amounts should be indicated by a minus sign. Round operating margin loss to decimal places ie should be entered as Roundall other answers to nearest whole dollar. begintabularcccccccccc
hline & multicolumncFrozen Food & multicolumncBaked Goods & multicolumnlFresh Produce
hline multicolumnc
hline multicolumnl
hline & $ & & & $ & & & $ & &
hline multicolumnl
hline Operating income loss & & & & & & & & &
hline Operating margin loss & & & & & & & & &
hline
endtabularbegintabularllllll
hline & multicolumnc Frozen Food & multicolumnc Baked Goods & multicolumnc Fresh Produce
hline & & & & &
hline & & & & &
hline Store support: & & & & &
hline & & & & &
hline & & & & &
hline & & & & &
hline & & & & &
hline Total store support cost & & & & &
hline Operating income loss & & & & &
hline Operating margin loss & & & & &
hline
endtabular
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
