(Solution) 12 Month Sales History Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2015 2016 Actual Committed Orders Orders 6,600 6,680 6,560 6,350 6,800 6,400... | Snapessays.com


(Solution) 12 month sales History Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2015 2016 Actual Committed Orders Orders 6,600 6,680 6,560 6,350 6,800 6,400...


Would like help using moving average and exponential smoothing forecast done by UTC 10:00pm12 month sales History

 

Raw Materials

 

2015

 

2016

 

Lead Time

 

Safety Stock

 

Actual Committed

 

BOM

 

On-Hand

 

Lot Size

 

Cost

 

Months

 

?

 

?

 

?

 

Amount

 

Orders

 

Orders

 

Handles

 

4

 

3,308

 

1,770 $

 

8.42

 

1

 

97.0%

 

3,000

 

500

 

Jan

 

6,600

 

6,680

 

Coils

 

7

 

850

 

880 $

 

469.95

 

2

 

95.0%

 

675

 

300

 

Feb

 

6,560

 

6,350

 

Boxes

 

1

 

2,450

 

40 $

 

74.00

 

1

 

50.0%

 

1,500

 

450

 

Mar

 

6,800

 

6,400

 

Apr

 

7,050

 

5,900

 

May

 

7,200

 

5,575

 

Human Resources

 

Jun

 

6,800

 

4,200

 

34 employees available Jan to April

 

Jul

 

5,900

 

740

 

1 new employees hired in May

 

Aug

 

7,100

 

100

 

Sep

 

7,200

 

3,700

 

Finance / Accounting

 

Oct

 

7,300

 

6,850

 

$

 

744 Regular production costs

 

Nov

 

7,250

 

7,990

 

$

 

790 Overtime production costs

 

Dec

 

7,350

 

8,000

 

$

 

836 Subcontractor production costs

 

$

 

1,750 to hire or layoff one employee

 

$

 

808 carrying costs

 

$

 

466 Backlog costs

 

Operations

 

Each employee produces:

 

200 ZX3s per month

 

ZX3s are produced in lots of

 

550 in each lot

 

ZX3 lead time

 

1 month

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147602047.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote