Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer all sub-questions clearly and neatly, as well as indicate where they begin and end Sahana is the new manager of a warehouse for

Please answer all sub-questions clearly and neatly, as well as indicate where they begin and end

image text in transcribed

image text in transcribed

Sahana is the new manager of a warehouse for Footwear manufacturing in Wollongong. She has been asked to estimate future monthly purchase costs for material no. 344 used in the factory. Sahana's purchase and quantity data for the past nine months are as follows: Month Cost of purchase Quantity purchased January $12 675 2 710 metres February 13 000 2 810 March 17 653 4 153 April 15 825 3756 May 13 125 2 912 June 13 814 3 387 July 15 300 3622 August 10 233 2 298 September 14 950 3 562 Estimated monthly purchases for this material, based on expected demand of products for the rest of the year, are: Month Purchase quantity expected October 3 340 metres November 3 710 metres December 3 040 metres Required a) The computer in Sahana's office is down, so you are asked to help her 15 marks to prepare a cost function to estimate the future purchase cost for material no. 344 using the high-low method. b) Using the equation from requirement 1, calculate the future expected 10 marks purchase costs for each of the last three months of the year. c) After a few hours the computer is fixed and you can use it to determine 25 marks the cost function using regression method to estimate future purchase cost for material 344 and obtain the cost function: y = $2 582.57 + 3.54X. Using the regression results, calculate the expected purchase costs for October, November and December. Compare the expected purchase costs with the expected purchase costs calculated using the high-low method in requirement b. Comment on your results

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_2

Step: 3

blur-text-image_3

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

ISE Fundamentals Of Cost Accounting

Authors: William N. Lanen, Shannon Anderson, Michael W. Maher

6th Edition

1260569098, 9781260569094

More Books

Students also viewed these Accounting questions

Question

Define and discuss the nature of communication

Answered: 1 week ago

Question

Define and discuss the nature of culture

Answered: 1 week ago