Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prest Metal Products manufactures and sells various products. The products are manufactured at one of a few plants ( depending on the product ) and

Prest Metal Products manufactures and sells various products. The products are manufactured at one of a few plants (depending on the product) and then shipped to a distribution center for eventual delivery to customers. The Auburn Distribution Center (ADC) of Prest Metal Products handles a subset of Prest Products. The products handled by the ADC are fairly similar in size and weight and differ primarily in features that do not affect handling or packaging.
When the sales staff at Prest receives an order, they send it to the appropriate distribution center to fill (collect units and package for shipping) and ship the units to the customer. A single order may consist of one (although unusual) or more units. Regardless of the number of units in the order, ADC has to follow certain steps to process the order, such as verifying the customer's address and credit information, review the order for errors, and so on. The ADC is also responsible for following up on any complaints from the customer about problems with the order.
The ADC expects to distribute 250,000 units of products next month. As a part of the normal planning process at ADC, the center controller has classified next month's expected operating costs (excluding costs of the distributed product) as fixed or variable (with respect to units shipped) as follows.
Account Operating Costs Behavior
Administration $ 37,800 $ 35,600 Fixed
Center labor 307,800 $ 145,100 Fixed
Center lease 128,600 $ 103,600 Fixed
Depreciation on equipment 125,800 $ 115,600 Fixed
Miscellaneous 128,200 $ 57,600 Fixed
Order processing 179,600 $ 41,600 Fixed
Supervision 77,100 $ 53,600 Fixed
Supplies (including packing materials)202,100 All Variable
Utilites 86,800 $ 63,600 Fixed
Total $ 1,273,800
The center manager has asked the financial staff for more information about center costs and whether there is a better way to estimate them rather than having the controller go through the monthly account analysis. The center manager assigned the controller's staff to recommend improvements to the current process.
Historically, all the financial and operation performance measures at ADC have been based on the number of units shipped. However, in preparing the analysis, one of the analysts on the controller's staff collected information from the last twelve months on orders processed as well as units shipped and ADC operating costs. These follow here:
Month Units Orders Center Cost
1241,97010,790 $ 999,030
2248,05016,4801,225,270
3245,35013,2101,065,200
4260,21015,3901,205,640
5256,16016,9501,222,520
6270,34013,6101,222,130
7251,43016,2101,157,860
8281,82012,8601,216,990
9272,3608,8901,137,190
10287,90012,2701,164,550
11285,20013,2801,183,470
12295,37011,4701,216,902
The controller and other managers at ADC agree that operations and costs last year were representative for the center.
a-1. Based on the controller's analysis of accounts, what is the variable cost per case?
Note: Round your answer to 2 decimal places.
a-2. Assuming that 275,000 units will be shipped in a future month, prepare an estimate of operating costs.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

7th Edition

978-0470477151, 978-0-470-5562, 470556242, 0-470-55624-2, 9780470556245, 978-0470507018

More Books

Students also viewed these Accounting questions

Question

How many files are in the Master File?

Answered: 1 week ago