Month Purclusing Cost Number of Purchase Orders January February March April Мay June July August September $18,860 18,065 19,250 18,050 19,345 19,500 19,670 20,940 19,430 20,020 18,800 19,340 370 330 370 410 400 450 460 560 440 October 500 November December 470 480

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Dohini Manufacturing company had following 12 months of data on purchasing cost and number of purchase orders.

Required:

1. Determine the high point and low point.

2. Calculate the variable rate for purchasing cost based on the number of purchase orders. (Round to nearest cent)

3. Calculate the fixed monthly cost of purchasing.(Round to nearest dollar).

4. Write the cost formula for the purchasing activity showing the fixed cost and the variable rate.

5. If Dohini manufacturing company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for the that month?(Round to nearest dollar)

6. What if Dohini manufacturing wants to estimate purchasing cost for the coming year and expects 5340 purchase orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesn't equal the fixed cost calculated in Requirement 3?(Round to nearest dollar)

Month
Purclusing Cost
Number of Purchase Orders
January
February
March
April
Мay
June
July
August
September
$18,860
18,065
19,250
18,050
19,345
19,500
19,670
20,940
19,430
20,020
18,800
19,340
370
330
370
410
400
450
460
560
440
October
500
November
December
470
480
Transcribed Image Text:Month Purclusing Cost Number of Purchase Orders January February March April Мay June July August September $18,860 18,065 19,250 18,050 19,345 19,500 19,670 20,940 19,430 20,020 18,800 19,340 370 330 370 410 400 450 460 560 440 October 500 November December 470 480
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.