ACC 341 MSU Jamestown Electric Warehousing and Shipping Case Excel Sheet

User Generated

wblllll

Business Finance

acc 341

Michigan State University

ACC

Description

ALL REQUIREMENTS ARE IN THE "ABC assignment guide"

Plz answer in the excel " ABC assignment template"

The Case background in in pdf

And also I put some ABC concept, feel free to look.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi, here is your assignment :) I also created cost system to support the customer profit.

Cost system: warehousing and shipping
Activity
Inventory Storage & Handling
Facility
Pulling and Shipping (total $9,820,000)
Set up order & prep shipment
Load and ship
Special handling
Total Warehousing & shipping

Total IDC (Exhibit 4)
Quantity of Alloc Base
Allocation Base
$
3,085,000 $
16,630,890 $$ of inventory stored in facilities
$
5,400,000 $
16,630,890 $$ of inventory stored in facilities
$
$
$
$

982,000
2,946,000
5,892,000
18,305,000

7800 # of orders processed

$
$

230,000,000 $$ of retail value of inventory shipped
100,256,410 $$ of special-order sales

Indirect cos...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags