Midwest Office Products

Topics: Costs, Cost, Revenue Pages: 4 (783 words) Published: December 11, 2007
1.Based on the interviews and data in the case, we calculated the following information.

(1)The cost of processing cartons through the facility:

Personnel expense (warehouse, truck drivers)2,570,000
¡ÐCompensation for truck drivers( 250,000)
Warehouse personnel expense$2,020,000
¡ÏWarehouse expenses (excluding personnel) 2,000,000
$4,020,000

(2)The cost of entering electronic and manual customer orders:

Order entry expenses$ 840,000

(3)The cost of shipping cartons on commercial carriers:

Freight$ 450,000

(4)The cost per hour for desktop deliveries:

Compensation for truck drivers $250,000
¡ÏDelivery truck expenses 200,000
The cost for desktop deliveries $450,000
¡Ò 6,000 hrs (1,500hr ¡Ñ 4)¡Ò 6,000
$ 75

2.The cost and profitability of the five orders, using the cost driver information and its existing costing system: (1)The ABC system:

Order12345
Sales$610.00$ 634.00$6,100.00$6,340.00$6,100.00
Cost of goods sold 500.00500.00 5,000.005,000.00 5,000.00 Gross margin$110.00$ 134.00$1,100.00$1,340.00$1,100.00 Cost of :
entering electronic order1a $ 3.50$ ¡Ð$ 3.50$ ¡Ð $ ¡Ð entering manual order1b ¡Ð7.88 ¡Ð 31.50 31.50 processing cartons2 50.25 50.25 502.50 502.50 502.50 shipping cartons commercially3

6.00
¡Ð
60.00
¡Ð
60.00
desktop deliveries ¡Ð 300.00 ¡Ð 300.00 ¡Ð interest on A/R balance 6.10 25.36 61.00 253.60244.00 general and selling expenses4
20.00
20.00
200.00
200.00
200.00
subtotal( 85.85)(403.49)(827.00)(1,287.60)(1,038.00) Net income (loss) before tax$ 24.15$(269.49)$ 273.00$ 52.40$ 62.00

(2)The existing costing system:

Order12345
Sales$610.00$ 634.00$6,100.00$6,340.00$6,100.00
Cost of goods sold 500.00500.00 5,000.00...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Midwest Office Products Case Essay
  • Midwest Office Products Essay
  • Midwest Office Products Essay
  • Midwest Office Products Essay
  • Essay on Midwest Office Products Management Accounting
  • Dakota Office Products Essay
  • Cost Management Midwest Office Essay
  • Office Dakota Products Case Analysis Essay

Become a StudyMode Member

Sign Up - It's Free