Total operating cost if the optimal plan is followed.

Deacon Building Supply, Inc. (DBS) has been awarded a contract to supply lumber for contractors working on Deacon Village, a mixed residential/retail area for students attending Deacon University. DBS owns and operates two sawmills, one on Reynolda Road and the other on Northwest Blvd. Both mills operate full days. The Reynolda mill costs $30,000 per day to operate and can produce 600 board feet of pine, 450 board feet of spruce, and 300 board feet of oak each day. The Northwest plant costs $38,000 per day to operate and can produce 450 board feet of pine, 600 board feet of spruce, and 750 board feet of oak each day. DBS has orders from 28 contractors for a total of 37,500 board feet of pine, 30,500 board feet of spruce, and 45,000 board feet of oak. DBS wants to minimize operating costs. Use Excel, best practices, and the most appropriate analytical technique to determine:
1) The optimal number of days Reynolda should operate.
2) The optimal number of days Northwest should operate.
3) Total operating cost if the optimal plan is followed.
0 ptsQ question 3
Upload
Upload the Excel file you used to answer the above question.
Choose a File
50 ptsQ uestion 4
12/3/21, 7:07 AM Quiz: ACC 706 Fall 2021 Exam 03
https://wakeforest.instructure.com/courses/32582/quizzes/48014/take 4/6
The DeacStore has over 9900 customers. The transaction amount, customer age, and if the customer has a family affiliation with WFU (student, alumni, parent, etc.) for a random sample of customers is provided in the attached file TFA2.xlsx (https://wakeforest.instructure.com/courses/32582/files/2090358?wrap=1) (https://wakeforest.instructure.com/courses/32582/files/2090358/download? download_frd=1) . Specify the most appropriate linear model for testing the relationship between transaction amount and family affiliation with WFU. Using Excel, best practices, the most appropriate analytical techniques, and no family affiliation as the base case, answer the following questions:
1) How many observations are in this data set?
2) What is the average transaction amount for customers who do not have a family affiliation with WFU?
3) By how much would you expect your answer to 2) to differ from that for all 7500 customers?
4) What is the probability you would get the answer you did to 2) if family affiliation has nothing to do with transaction amount?
5) How much higher is the average transaction amount for customers who have a family affiliation with WFU than the average transaction amount for customers who do not have a family affiliation with WFU? If the transaction amount is lower, enter your answer as a negative number.
6) By how much would you expect your answer to 5) to differ from that for all 7500 customers?
7) What is the probability you would get the answer you did to 5) if family affiliation has nothing to do with transaction amount?
12/3/21, 7:07 AM Quiz: ACC 706 Fall 2021 Exam 03
https://wakeforest.instructure.com/courses/32582/quizzes/48014/take 5/6
8) How much of the variation in transaction amount can be attributed to family affiliation with WFU?
9) What would you predict to be the transaction amount for a customer who has a family affiliation with WFU?
10) Your predicted transaction amounts, based on family affiliation with WFU, will be off by how much, on average?
0 ptsQ uestion 5
Upload
Upload the Excel file you used to answer the above question.
Choose a File
5 ptsQ uestion 6
An analyst at Deacon Industries, Inc. optimized the production of four different birdhouses. After running Solver, she noticed the following:
Component Consumed Available Wood (square feet) 8,500 10,000 Nails (number) 500 500 Glue (oz) 750 750 Dowels (number) 300 300
12/3/21, 7:07 AM Quiz: ACC 706 Fall 2021 Exam 03
https://wakeforest.instructure.com/courses/32582/quizzes/48014/take 6/6
Quiz saved at 7:07am
Wood
Nails
Glue
Dowels
Which component would be considered a slack constraint?
Submit Quiz