Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FILENAME: CH12_P10.xlsx CHAPTER 12, PROBLEM 10 ENTER THE DATA WHERE YOU SEE THE HIGHLIGHTED NAs IN THE INPUT SECTION AND INPUT YOUR DESIRED STRATEGY IN
| FILENAME: CH12_P10.xlsx | ||||||||
| CHAPTER 12, PROBLEM 10 | ||||||||
| ENTER THE DATA WHERE YOU SEE THE HIGHLIGHTED "NA"s IN | ||||||||
| THE INPUT SECTION AND INPUT YOUR DESIRED STRATEGY | ||||||||
| IN THE PLANNING TABLE. | ||||||||
| THE RESULTS OF THE STRATEGY WILL BE CALCULATED | ||||||||
| AUTOMATICALLY. | ||||||||
| PRESS THE "PAGE DOWN" KEY TO ACCESS THE INPUT SECTION | ||||||||
| AND THE PLANNING TABLE. | ||||||||
| PRESS "CTRL" AND "P" AT THE SAME TIME AND CHOOSE "OK" FOR | ||||||||
| PRINTED OUTPUT. | ||||||||
| NAME: | *************** | CHAPTER 12, PROBLEM 10 | ||||||
| SECT: | *************** | DATE: | 3-Dec-15 | |||||
| INPUT SECTION: | ||||||||
| PRESENT LABOR FORCE (employees)............................. | #N/A | |||||||
| TOYS PER WORKER PER MONTH IN $000....................... | #N/A | |||||||
| REGULAR WAGE RATE PER MONTH............................. | #N/A | |||||||
| OVERTIME RATE (% of regular time) ......................................... | #N/A | |||||||
| INVENTORY CARRYING CHARGE (% per year)............... | #N/A | |||||||
| HIRING COSTS ($ per worker)............................................. | #N/A | |||||||
| LAYOFF COSTS ($ per worker)......................................... | #N/A | |||||||
| BEG INVENTORY IN $000................................................... | #N/A | |||||||
| DEMAND IN THOUSANDS OF DOLLARS | ||||||||
| JULY | #N/A | OCT | #N/A | |||||
| AUG | #N/A | NOV | #N/A | |||||
| SEPT | #N/A | DEC | #N/A | |||||
| TOTAL... | . | #N/A | ||||||
| STRATEGY: | **************** | |||||||
| MONTH | ||||||||
| JULY | AUG | SEPT | OCT | NOV | DEC | TOTAL | ||
| RESOURCES: | {PRODUCTION, SALES, AND INVENTORIES IN $000} | |||||||
| REG WORKER: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
| O.T. % | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
| PRODUCTION | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
| SALES: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
| INVENTORY | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
| - | - | - | - | - | - | - | - | |
| COSTS: {IN DOLLARS} | ||||||||
| REG. TIME: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
| OVERTIME: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
| HIRE/FIRE: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
| INVENTORY: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
| = | = | = | = | = | = | = | = | |
| TOTAL: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | |
|
How do I work this problem in excel with formulas. | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started