- Assuming There Is An Order Of 600 Shelves For Each Type Of Bookshelves And Operations Will Start January 1 2021 And The 1 (32.85 KiB) Viewed 67 times
- Assuming There Is An Order Of 600 Shelves For Each Type Of Bookshelves And Operations Will Start January 1 2021 And The 2 (27.93 KiB) Viewed 67 times
- Assuming There Is An Order Of 600 Shelves For Each Type Of Bookshelves And Operations Will Start January 1 2021 And The 3 (68.71 KiB) Viewed 67 times
- Assuming There Is An Order Of 600 Shelves For Each Type Of Bookshelves And Operations Will Start January 1 2021 And The 4 (68.71 KiB) Viewed 67 times
- Assuming There Is An Order Of 600 Shelves For Each Type Of Bookshelves And Operations Will Start January 1 2021 And The 5 (63.55 KiB) Viewed 67 times
- Assuming There Is An Order Of 600 Shelves For Each Type Of Bookshelves And Operations Will Start January 1 2021 And The 6 (65.47 KiB) Viewed 67 times
1. The amount of net profit after the completion of all the order. 2. When will be t order completed? 3. Compute for the takt time. 4. If all the orders need to be completed by March 30, how many additional full-time employees must be added during the weekday shift (New workers will be added at the start of the year) Make a new spreadsheet model for this one. If all the onders need to be completed by March 30, how many additional full-time employees must be added during the weekday shit Diew workers will be added at the start of March S 6. Create a scenario summary for profit based on current cost of wood (scenario 3) and the cost of wood the next year (scenario 23 7. This can be done in a separate spreadsheet. Create a one-way data table for the profit using average annual increase in the cast of wood for all the boe helves
Make a spreadsheet model from the following data. Assuming there is an order of 600 shelves for each type of bookshelves and operations will start January 1, 2021 and the company operates 7 days a week (both weekdays and weekends and let's say there is no holiday) with 20 full time workers on duty during weekdays and 10 workers during weekends. There is one-part time worker that works every whole day of Wednesday and Saturday. Projecting bookshelf costs at Woodworks Inputs Requirements per bookshelf Board-feet required Labor hours required Costs of wood Current cost per board-foot Projected annual increase Cost of labor per hour Weekdays Holidays Weekends Cherry 30 16 Cherry $7.30 2.4% $ 24.00 $ 20.00 Oak 30 16 Hourly Wage rate $14.00 Cherry Oak $4.30 1.7% Oak Pine 32 18 Pine $8.75 2.5% Pine Synthetic 28 10 Synthetic $9.75 5.0% Synthetic
4 Cherry 160% 1. 2. 3. Compute for the takt time. Summer%202022%20(OSCM%205130).p... to Mark up for Selling Price Selling Price = Mark up X Average Cost per Product type Average Cost per Product type = Total Cost per product type / Order Quantity 4 Ock 100% Your spreadsheet model must be able to provide the following values: The amount of net profit after the completion of all the order. When will be the order completed? 240% 220% 4. If all the orders need to be completed by March 30, how many additional full-time employees must be added during the weekday shift. (New workers will be added at the start of the year). 5. Make a new spreadsheet model for this one. If all the orders need to be completed by March
4. If all the orders need to be completed by March 30, how many additional full-time employees must be added during the weekday shift. (New workers will be added at the start of the year). 5. Make a new spreadsheet model for this one. If all the orders need to be completed by March 30, how many additional full-time employees must be added during the weekday shift. (New workers will be added at the start of March). 6. Create a scenario summary for profit based on current cost of wood (scenario 1) and the cost of wood the next year (scenario 2). 7. This can be done in a separate spreadsheet. Create a one-way data table for the profit using average annual increase in the cost of wood for all the bookshelves.