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
The precise and brief annotated bibliography submitted by the writing expert at HwA for my World Religion thesis paper was just what my professor had asked for. There was no problem in communication between the writing expert and me and the research work done was absolutely spot on.
I had a research assignment where I needed to write a report on the local markets of Singapore. It was difficult getting help online as most of these assignment help services are located abroad somewhere in USA or UK. I was happy to see that HwA has tutors from Singapore itself and they dedicatedly cater to students like us, who are from or studying in Singapore
You guys never fail to surprise me. Thanks for helping me with my finance assignment.
My balance sheet never tallied before I approached HwA for help. I always used to mess things up. My ideas regarding the items to be entered where shady and I needed serious help. The balance sheet experts of HwA were of a great help and now I have gained much confidence in the subject.
Religion as a subject is quite sensitive and I needed my world religion assignments to be worded and structured in such a manner so that the analysis was objective and did not appear to be biased or insensitive. The assignment writers at TheReliableTutor.com understood my requirement and with their expertise in writing managed to provide the assignments exactly the way I wanted
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.