View the step-by-step solution to:

Yasuko's Art Emporium (YAE) ships art from its studio located in the Far East to its distribution center located on the West Coast of the United

home work chp 12,13,14
Background image of page 1
Air Freight Freight Serv Time 2 15 Demand 18,000 18,000 Avg Tran Inv (ATI) What additional information would be needed to make a comparison? Yasuko's Art Emporium (YAE) ships art from its studio located in the Far East to its distribution center located on the West Coast of the United States. YAE can send the art either via transoceanic ship freight service (15 days transit) or by air freight (2 days transit time). YAE ships 18,000 pieces of art annually. 365 tD ATI
Background image of page 2
Show entire document
Problem 2 Use table 13-12 for formulas Use data from Problem Data in text, pg. 534 Cost data Period 1 2 3 4 5 6 Total Regular-time labor cost per hour $10.00 Demand Overtime labor cost per hour $15.00 Cumulative Demand Subcontracting cost per unit (labor only) $84.00 Cum Dem/#Periods 0 Holding cost per unit per period $10.00 Period Production use the max of the row above. Back-order cost per unit per period $20.00 Cum Production Hiring cost per employee $600.00 Ending Inventory Firing cost per employee $450.00 Capacity data Number of employees Beginning workforce 210 employees Number to hire Beginning inventory 400 units Number to fire Labor standard per unit 6 hrs 26.66667 Regular-time available per period 160 hours 4 wks Costs of Plan Overtime available per period 32 hrs Regular time labor Subcontracting maximum per period 1000 units Holding costs Subcontracting minimum per period 500 units Hiring Demand data Total costs Period 1 6000 units Period 2 4800 units Cost per unit Period 3 7840 units Period 4 5200 units Period 5 6560 units Period 6 3600 units $0.00
Background image of page 1
Problem 3 Use table 13-12 for reference CHASE PLAN Cost data Period 1 2 3 4 5 6 Total Regular-time labor cost per hour $10.00 Demand (net of beg inventory) 5,600 4,800 7,840 5,200 6,560 3,600 33,600 Overtime labor cost per hour $15.00 Production per period =F4 Subcontracting cost per unit (labor only) $84.00 Employees needed in period =F5/D14 Holding cost per unit per period $10.00 Number to hire =MAX(B12-F7,0) Back-order cost per unit per period $20.00 Number to fire =MAX(F7-B12,0) Hiring cost per employee $600.00 Firing cost per employee $450.00 Costs of Plan Capacity data Regular time labor = total employees needed X regular hours per period X labor cost per hour Beginning workforce 210 employees Hiring Cost = total hired X hiring cost per employee Beginning inventory 400 units Firing Costs = total fired X firing cost per employee Labor standard per unit 6 hrs 27 Total costs = total of all costs above Regular-time available per period 160 hours 4 wks Cost per unit = the total of all costs divided by the total units produced Overtime available per period 32 hrs Subcontracting maximum per period 1000 units Subcontracting minimum per period 500 units Demand data Period 1 6000 units Period 2 4800 units Period 3 7840 units Period 4 5200 units Period 5 6560 units Period 6 3600 units
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

Hi, Attached the solution for chapter 12 and... View the full answer

Ch12hwk.xlsx

Yasuko's Art Emporium (YAE) ships art from its studio located in the Far East to its distribution center located on the West Coast of the United States. YAE can send the art either via...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online