Question: Questions are stated below please help. Find the values for the chase strategy in the chart below and answer the questions below. Paste B E

Questions are stated below please help. Find the values for the chase strategy in the chart below and answer the questions below.

Questions are stated below please help. Find the values for the chase

strategy in the chart below and answer the questions below. Paste B

E Merge & Center v % 038 cond Formal Formatting as Table

Paste B E Merge & Center v % 038 cond Formal Formatting as Table Styles IF Format SOIL Filter Finc Select Ralyze Data C10 fx B C E F G I J K L M N 0 P Q R 5 5 T 20 7.5 150 How many hours per month does cach employee work? 1 Production Data 2 Workdays per month 3 Hours per workday Regular timc hours per month per cm playen 5 Labor standard-labor hours per table 6 On-hand inventory Itables 7 Current workforce (workers 8 Overtime hours per worker per month 2.5 300 25 20 1500 How many tables can 25 employees make in a month? 27.5 4.67 15.83 41.25 3 14 10 Cost Data 11 Labar cast is partable 12 Hiring costs ($ per table increase 13 Firing casts Is per partable decrease 14 Overtime costs are 1.5 times hours wace 15 Inventory carrying costs (sportable per manth) 15 Stockout costs ($ per table) 17 18 Demand 19 Jan 20 Feb 21 Mar 22 Apr 23 May 24 Jun 25 6-month total 6 26 27 28 29 30 21 Tables 1740 1740 2460 3240 2220 1960 13260 Chase Strategy 1st Month Production = 1st Month Demand - Beginning Inventory Ending inventory Available inventory Change in Shortage production Increase in production Decrease in production Demand Production Previous plan Jan 1740 Feb 1740 Mar 2460 3240 Apr May Jun 2220 1860 13260 Total Cost Number of months 6 QUESTION 1 What is the chase production amount for the 1st month for La Mesa Abundante? (provide 0 decimal places) QUESTION 2 For the increase in production, what is the cost? (Do not use $ signs) QUESTION 3 What is the total cost for the chase strategy? (no decimal places) Paste B E Merge & Center v % 038 cond Formal Formatting as Table Styles IF Format SOIL Filter Finc Select Ralyze Data C10 fx B C E F G I J K L M N 0 P Q R 5 5 T 20 7.5 150 How many hours per month does cach employee work? 1 Production Data 2 Workdays per month 3 Hours per workday Regular timc hours per month per cm playen 5 Labor standard-labor hours per table 6 On-hand inventory Itables 7 Current workforce (workers 8 Overtime hours per worker per month 2.5 300 25 20 1500 How many tables can 25 employees make in a month? 27.5 4.67 15.83 41.25 3 14 10 Cost Data 11 Labar cast is partable 12 Hiring costs ($ per table increase 13 Firing casts Is per partable decrease 14 Overtime costs are 1.5 times hours wace 15 Inventory carrying costs (sportable per manth) 15 Stockout costs ($ per table) 17 18 Demand 19 Jan 20 Feb 21 Mar 22 Apr 23 May 24 Jun 25 6-month total 6 26 27 28 29 30 21 Tables 1740 1740 2460 3240 2220 1960 13260 Chase Strategy 1st Month Production = 1st Month Demand - Beginning Inventory Ending inventory Available inventory Change in Shortage production Increase in production Decrease in production Demand Production Previous plan Jan 1740 Feb 1740 Mar 2460 3240 Apr May Jun 2220 1860 13260 Total Cost Number of months 6 QUESTION 1 What is the chase production amount for the 1st month for La Mesa Abundante? (provide 0 decimal places) QUESTION 2 For the increase in production, what is the cost? (Do not use $ signs) QUESTION 3 What is the total cost for the chase strategy? (no decimal places)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!