Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1: You work in the HR department of a large commercial agricultural producer. Due to the nature of your business, your labor demand is highly

image text in transcribedimage text in transcribedimage text in transcribed

Q1: You work in the HR department of a large commercial agricultural producer. Due to the nature of your business, your labor demand is highly seasonal. That is, you need considerably more labor during the harvest season (and to a lesser extent during the planting season) compared to the other times of the year. Based on historical employment data, you have determined that your labor demand can be modeled by the equation: Demand=k+.3t1+csin(1.1t) Where: - t is the month of your fiscal year (Sept to August). - k&c are scaling parameters determined by the modeling process - Demand is your labor demand in hundreds of full time equivalent (FTE) workers Use Excel's built-in optimization functions (data > analysis > solver) to answer the questions below. For this problem, use the GRG nonlinear solver. 1. What is your projected labor demand in October (i.e., month 2)? 2. Starting there, what is your minimum projected labor demand (use solver)? a. When does it occur (month, including 2 decimals)? 3. What is your projected labor demand in April (i.e., month 8)? 4. Starting there, what is your minimum projected labor demand? a. When does it occur (month, including 2 decimals)? 5. How do your answers to Q2&Q4 compare? Why? Q1: You work in the HR department of a large commercial agricultural producer. Due to the nature of your business, your labor demand is highly seasonal. That is, you need considerably more labor during the harvest season (and to a lesser extent during the planting season) compared to the other times of the year. Based on historical employment data, you have determined that your labor demand can be modeled by the equation: Demand=k+.3t1+csin(1.1t) Where: - t is the month of your fiscal year (Sept to August). - k&c are scaling parameters determined by the modeling process - Demand is your labor demand in hundreds of full time equivalent (FTE) workers Use Excel's built-in optimization functions (data > analysis > solver) to answer the questions below. For this problem, use the GRG nonlinear solver. 1. What is your projected labor demand in October (i.e., month 2)? 2. Starting there, what is your minimum projected labor demand (use solver)? a. When does it occur (month, including 2 decimals)? 3. What is your projected labor demand in April (i.e., month 8)? 4. Starting there, what is your minimum projected labor demand? a. When does it occur (month, including 2 decimals)? 5. How do your answers to Q2&Q4 compare? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Course In Derivative Securities

Authors: Kerry Back

2005th Edition

3540253734, 978-3540253730

More Books

Students also viewed these Finance questions

Question

13. Identify several ways to collect narratives.

Answered: 1 week ago