Get in touch with us
Send us an e-mail
Question
Digital Cell Phone, Inc.
Paul Jordan has just been hired as a management analyst at Digital Cell Phone, Inc. Digital Cell manufactures a broad line of phones for the consumer market. Paul’s boss, John Smithers, chief operations officer, has asked Paul to stop by his office this morning. After a brief exchange of pleasantries over a cup of coffee, he says he has a special assignment for Paul: “We’ve always just made an educated guess about how many phones we need to make each month. Usually we just look at how many we sold last month and plan to produce about the same number. This sometimes works fine. But most months we either have too many phones in inventory or we are out of stock. Neither situation is good.”
Handing Paul the table shown here, Smithers continues, “Here are our actual orders entered for the past 36 months. There are 144 phones per case. I was hoping that since you graduated recently from the University of Alaska, you might have studied some techniques that would help us plan better. It’s been awhile since I was in college—I think I forgot most of the details I learned then. I’d like you to analyze these data and give me an idea of what our business will look like over the next 6 to 12 months. Do you think you can handle this?”
“Of course,” Paul replies, sounding more confident than he really is. “How much time do I have?”
“I need your report on the Monday before Thanksgiving—that would be November 20th. I plan to take it home with me and read it during the holiday. Since I’m sure you will not be around during the holiday, be sure that you explain things carefully so that I can understand your recommendation without having to ask you any more questions. Since you are new to the company, you should know that I like to see all the details and complete justification for recommendations from my staff.”
With that, Paul was dismissed. Arriving back at his office, he began his analysis.
TABLE—Orders Received, by Month
|
Month |
Cases |
Cases |
Cases |
|
January |
480 |
575 |
608 |
|
February |
436 |
527 |
597 |
|
March |
482 |
540 |
612 |
|
April |
448 |
502 |
603 |
|
May |
458 |
508 |
628 |
|
June |
489 |
573 |
605 |
|
July |
498 |
508 |
627 |
|
August |
430 |
498 |
578 |
|
September |
444 |
485 |
585 |
|
October |
496 |
526 |
581 |
|
November |
487 |
552 |
632 |
|
December |
525 |
587 |
656 |
Discuss
1. Prepare Paul Jordan’s report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul’s response.
2. Adding seasonality into your model, how does the analysis change?
Summary
This question belongs to statistics and discusses about regression analysis of Digital Cell Phone Inc.
Word count: NA
Download Full Solution
We were practically bombarded with assignments pertaining to magnetism and electro-magnetism, when I became desperate and started searching help online. Luckily I landed on this page and since then I always approach them for help. They are professional in their approach and get the job done, no matter what.
After I started my course in Systems Diagramming and the Process Map using ERP, I was soon losing grip of the things as the teacher was moving too fast. Then eventually I came across HwA where the experts helped me with my assignments and also cleared my concepts.
I was completely lost with my Thermodynamics assignment. I approached the HwA team for help and they connected me with the best chem engineering tutor ever. He not only cleared my concepts but also helped me in solving my assignments. Kudos team!
I was unsure about a communicable disease case study assigned to me on my final year of nursing study. Then when I browsed through the net for help I landed on HwA and found that their experts are really well equipped with knowledge and expertise pertaining to the subject. I am really happy with the assistance I had received and I recommend this site for all nursing students.
Nuclear chemistry problems were turning into the bane of my life and i was just not able to get my head around the subject. But with the help of the nuclear chemistry assignment experts at HwA helped me understand the topics better than most of the other online assignment help services that i had used previously. It is affordable and the quality of assignment writing is definitely worth every cent I paid.
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.