Ch. 6 Times Series with Trend & Seasonality
Chapter 6
There are a total of four problems from 6 and Ch. 7. Submit three of them as indicated. (If you submit all 4, I will just grade the 3.) You may do all problems in the given Excel template or do Ch. 6 in the Excel template and Ch. 7 in Word.
To Submit: Ch6: D, Ch7: A, B
Ch. 6 Times Series with Trend & Seasonality
In the two problems here, you may use either Excel’s Data Analysis tool (available only in Windows) or LINEST function to find the regression coefficients. All work must be shown.
D
Hudson Marine has been an authorized dealer for C&D marine radios for the past six years. The number of radios sold each quarter is shown in the Excel template. Hudson Marine would like to forecast the quarterly sales for year 7.
(a) Construct a time series plot.
(b) Construct a multiple regression model with dummy variables to develop an equation that takes into account both trend and seasonality. Give the quarterly forecasts for year 7.
(c) Out of four quarters of the year, which quarter has the peak demand? Which quarter has the lowest demand?
Ch. 7 Linear Programming Formulation
A.
The Outdoor Furniture Corporation manufactures two products, benches and picnic tables. The firm has two main resources: its carpenters (labor force) and a supply of redwood for use in the furniture. During the next production cycle, 1,200 hours of labor are available under a union agreement. The firm also has a stock of 3,500 feet of goodquality redwood.
Each bench that Outdoor Furniture produces requires 6 labor hours and 12 feet of redwood; each picnic table takes 9 labor hours and 40 feet of redwood.
Completed benches will yield a profit of $10 each, and tables will result in a profit of $20 each.
(a) Let B = number of benches to produce and
T = number of tables to produce.
Write down the linear programming model to decide how many benches and tables should be produced to obtain the largest possible profit. Don’t attempt to solve the problem.
(b) Is B = 70, T = 70 feasible solution? How about B= 70, T = 60?
(c) Given an example of a feasible solution that yields total profit of at least $2,000. (There are many such solutions, just give one.) Decimal numbers are OK. The person(s) who gets the highest profit will get 1 extra point on this homework.
B.
Alpine Attic is the charity sponsored by local churches in Denver, Colorado. Literally thousands of items, including televisions and stereos, are donated each year, most in need of repair. Repaired televisions and stereos typically sell for $50 and $30 each at the Alpine Attic Thrift Store. To repair these, Alpine Attic depends on John Lucas who owns JL Electronics, a deacon at St. Paul’s Episcopal Church. Each month, he can donate 45 hours of an electrician’s time and 30 hours of a technician’s time. But this is not enough time to repair all of the televisions and radios donated.
To repair a television, it takes average of 90 minutes of electrician’s time and 30 minutes of a technician’s time.
To repair a stereo, it takes an average of 45 minutes of an electrician’s time and 60 minutes of a technician’s time.
Alpine Attic would like to determine how to best use the electrician’s and technician’s time to realize the maximum possible profit from the donated televisions and stereos. Write down a linear programming model to decide how many televisions and stereos should be repaired each month. Do not attempt to solve. Don’t forget to define the decision variables first.
Hudson Marines
Data & Computation
Year Quarter Sales (units)
1 1 12
2 20
3 17
4 9
2 1 16
2 28
3 25
4 14
3 1 21
2 30
3 27
4 20
4 1 24
2 36
3 30
4 23
5 1 26
2 38
3 32
4 22
6 1 30
2 42
3 37
4 29
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂
Topquality papers guaranteed
100% original papers
We sell only unique pieces of writing completed according to your demands.
Confidential service
We use security encryption to keep your personal data protected.
Moneyback guarantee
We can give your money back if something goes wrong with your order.
Enjoy the free features we offer to everyone

Title page
Get a free title page formatted according to the specifics of your particular style.

Custom formatting
Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.

Bibliography page
Don’t pay extra for a list of references that perfectly fits your academic needs.

24/7 support assistance
Ask us a question anytime you need to—we don’t charge extra for supporting you!
Calculate how much your essay costs
What we are popular for
 English 101
 History
 Business Studies
 Management
 Literature
 Composition
 Psychology
 Philosophy
 Marketing
 Economics