solution

/in /by
  • Complete the following tasks relating to Activity 2.8 on how to use information to support decision making
  • State your conclusions from the analysis
  • Recommend a course of action to improve the sales totals of the poorly performing salesman.
  • Your conclusions and recommendations should be justified.

Complete the following tasks relating to Activity 2.8 on how to use information to support decision...

Activity 2.8

You will notice that two reports have been generated for Daniel and Eric by setting the First Name criteria in cell A2. The Spreadsheet from Learning Activity 2.6 was used to derive Daniel’s report first by clearing all the criteria cells and then by entering the following formula into cell A2 =”=Daniel” Eric’s report was derived in a similar fashion by clearing cell A2 and entering =”=Eric” You are to now adopt the role of a manager within this company. In this role you are responsible for driving sales by effectively managing and developing the sales team. Review and compare Daniel’s figures against Eric’s and consider the questions below.

A. Based on the Total Sales information for Daniel and Eric which salesman is performing well and which is performing poorly?

B. From the Total and Average hours worked information can we determine if the salesman that is performing well is in fact achieving such successful sales totals by simply working longer hours? Does that explain why the sales figures differ so much?

C. From the Total, Average, Minimum and Maximum customers served information can we determine if the salesman that is performing well is in fact achieving such successful sales totals by simply approaching and serving more customers? Is the difference significant enough to explain why the sales figures differ so much? Can we conclude that the poorly performing salesman is simply shirking his duty and not seeking to serve customers?

D. What does the information possibly suggest about the skills of the two salesmen with respect to salesmanship?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

Draw an ERD for each of the following:

a. A sale can include many items and an item can be included on many sales.

b. A customer can place an order for different products sold by a retailer. A product may be sold on multiple orders and an order may be for many products.

c. An academic department at Texas A&M Commerce University offers multiple curricula and a curriculum is offered by one academic department. d. A building in Texas A&M Commerce University has multiple rooms and a room is located in a specific building.

e. The Marketing and Business Analytics Department at Texas A&M Commerce University offers courses that may have several prerequisites. Some of these courses may be a prerequisite to other courses.

f. An employee at Texas A&M Commerce University may work on different projects that may be run at multiple locations.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by
42. Explain The President of Greene and Rich College and the Dean of the School of Business Administration wish to forecast the enrollments for the Fall Semester. The enrollment is measured in Full Time Equivalents (FTE’s) which represents the number of full-time students. This is the equivalent to the existing mixture of full-time and part-time students. Data representing the Fall enrollment for the past ten years is given below: Unear Trend Time (t) Enrollment Naive 3 Period 6 Period Moving Moving Average Average 1 1984 N/A N/A N/A 2 2119 N/A NA 3 2188 N/A NA 4 2213 N/A 5 2268 N/A 6 2313 NA 7 2424 8 2453 9 2538 10 2629 11 42.1 Make a naive forecast for Year 11; 42.2 Make a 3 year moving average forecast for Year 11; [2] 42.3 Make a 6 year moving average forecast for Year 11; 12) 42.4 Based on your calculations above, which forecast would you use for planning proposes for Year 11 and why? Page 9 42.5 Below is a scatterplot of the FTE enrollments: les 2650 2500 2550 2500 2450 2400 2150 2100 2050 2000 30 42.5 Describe any trend you observe in the plotted data. [2] 42.6 If enrollment = a + bt=1954.9 +65.2t, what would be your forecast for Year 11; [2] 42.7 Based on all four of your calculations above, which forecast would you use for planning proposes for Year 11 and why? [2]
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

/in /by

Having trouble with Part C of this question. Unable to figure out the Min and developing a minimum cost schedule for the part-time employees. With this, I also need help to figure out the inequality for 7 pm, 8 pm, and 9 pm. I also need help with the optimal solution of Part C. The other parts are all correct.

A linear programming computer package is needed.

Western Family Steakhouse offers a variety of low-cost meals and quick service. Other than management, the steakhouse operates with two full-time employees who work 8 hours per day. The rest of the employees are part-time employees who are scheduled for 4-hour shifts during peak meal times. On Saturdays the steakhouse is open from 11:00 a.m. to 10:00 p.m. Management wants to develop a schedule for part-time employees that will minimize labor costs and still provide excellent customer service. The average wage rate for the part-time employees is $7.60 per hour. The total number of full-time and part-time employees needed varies with the time of day as shown.

Time Number of Employees Needed
11:00 a.m.–Noon 9
Noon–1:00 p.m. 9
1:00 p.m.–2:00 p.m. 9
2:00 p.m.–3:00 p.m. 3
3:00 p.m.–4:00 p.m. 3
4:00 p.m.–5:00 p.m. 3
5:00 p.m.–6:00 p.m. 6
6:00 p.m.–7:00 p.m. 12
7:00 p.m.–8:00 p.m. 12
8:00 p.m.–9:00 p.m. 7
9:00 p.m.–10:00 p.m. 7

One full-time employee comes on duty at 11:00 a.m., works 4 hours, takes an hour off, and returns for another 4 hours. The other full-time employee comes to work at 1:00 p.m. and works the same 4-hours-on, 1-hour-off, 4-hours-on pattern.

(a)

Develop a minimum-cost schedule for part-time employees. (Let

xi

= the number of part-time employees who start work beginning at hour i where

i = 1 = 11:00 a.m.,

i = 2 = Noon,

etc).Min

30.4×1?+30.4×2?+30.4×3?+30.4×4?+30.4×5?+30.4×6?+30.4×7?+30.4×8?

s.t.11:00 a.m.

x1?=8

Noon

x1?+x2?=8

1:00 p.m.

x1?+x2?+x3?=7

2:00 p.m.

x1?+x2?+x3?+x4?=1

3:00 p.m.

x2?+x3?+x4?+x5?=2

4:00 p.m.

x3?+x4?+x5?+x6?=1

5:00 p.m.

x4?+x5?+x6?+x7?=5

6:00 p.m.

x5?+x6?+x7?+x8?=10

7:00 p.m.

x6?+x7?+x8?=10

8:00 p.m.

x7?+x8?=6

9:00 p.m.

x8?=6

x1, x2, x3, x4, x5, x6, x7, x8 = 0

Find the optimal solution.

(x1, x2, x3, x4, x5, x6, x7, x8) =

(8, 0, 0, 0, 2, 0, 4, 6)

(b)

What is the total payroll (in $) for the part-time employees?

$

608

How many part-time shifts are needed?

20 shifts

Use the surplus variables to comment on the desirability of scheduling at least some of the part-time employees for 3-hour shifts.

There are 7 surplus employees that are scheduled from 2-3 p.m. and 4 surplus employees scheduled from 8-9 p.m. Based on this it would be desirable to rotate employees off sooner making this more beneficial.

(c)

Assume that part-time employees can be assigned either a 3-hour or a 4-hour shift. Develop a minimum-cost schedule for the part-time employees. (Let

xi

be the same variables from part a. Let

yi

= the number of part-time employees who start work beginning at hour i where

i = 1 = 11:00 a.m.,

i = 2 = Noon, etc).

Min : _________________________

s.t.11:00 a.m.

x1?+y1?=8

Noon

x1?+x2?+y1?+y2?=8

1:00 p.m.

x1?+x2?+x3?+y1?+y2?+y3?=7

2:00 p.m.

x1?+x2?+x3?+x4?+y2?+y3?+y4?=1

3:00 p.m.

x2?+x3?+x4?+x5?+y3?+y4?+y5?=2

4:00 p.m.

x3?+x4?+x5?+x6?+y4?+y5?+y6?=1

5:00 p.m.

x4?+x5?+x6?+x7?+y5?+y6?+y7?=5

6:00 p.m.

x5?+x6?+x7?+x8?+y6?+y7?+y8?=10

7:00 p.m.

_________

8:00 p.m.

_________

9:00 p.m.

_________

x1, x2, x3, x4, x5, x6, x7, x8, y1, y2, y3, y4, y5, y6, y7, y8, y9 = 0

Find the optimal solution.

(x1, x2, x3, x4, x5, x6, x7, x8, y1, y2, y3, y4, y5, y6, y7, y8, y9) =

(_______________________________________________)

How many part-time shifts are needed, and what is the cost savings compared to the previous schedule?

part-time shifts needed

20

cost savings

$106.40

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"