Categories
Excel

Young entrepreneur Fan Bingbing has launched a business venture in which she use

Young entrepreneur Fan Bingbing has launched a business venture in which she uses stories submitted by university students as the basis for comics in a monthly anime-style magazine. Based on market research, Fan estimates that average monthly demand will be 500 copies. She has decided to model monthly demand as the maximum of 0 and a normal random variable with a mean of 500 and a standard deviation of 300.
Fan must pay a publishing company $3.75 for each copy of the comic printed. She then sells the magazine for $5 each. Rather than having a storefront, Fan sells the magazines through a group of student vendors who sell the comics out of their backpacks while on campus. Fan pays a student vendor $0.35 for each magazine he/she sells. As Fan distributes a new issue each month, she only sells each issue for a month. However, the publishing company has agreed to buy back from Fan any unsold copies at the end of each month for $2.25. Create a simulation model with 1000 trials.
A. What is the estimate of the average profit if Fan sets the order quantity to 1,200? What is the 95% confidence interval on this estimate of average profit? (1+1/2 point)
B. What is the estimate of the average profit if Fan sets the order quantity to 1,000? What is the 95% confidence interval on this estimate of average profit? ( 1 point)
C. Which order quantity should Fan choose based on the average profit? (1/2 points)

Categories
Excel

Young entrepreneur Fan Bingbing has launched a business venture in which she use

Young entrepreneur Fan Bingbing has launched a business venture in which she uses stories submitted by university students as the basis for comics in a monthly anime-style magazine. Based on market research, Fan estimates that average monthly demand will be 500 copies. She has decided to model monthly demand as the maximum of 0 and a normal random variable with a mean of 500 and a standard deviation of 300.
Fan must pay a publishing company $3.75 for each copy of the comic printed. She then sells the magazine for $5 each. Rather than having a storefront, Fan sells the magazines through a group of student vendors who sell the comics out of their backpacks while on campus. Fan pays a student vendor $0.35 for each magazine he/she sells. As Fan distributes a new issue each month, she only sells each issue for a month. However, the publishing company has agreed to buy back from Fan any unsold copies at the end of each month for $2.25. Create a simulation model with 1000 trials.
A. What is the estimate of the average profit if Fan sets the order quantity to 1,200? What is the 95% confidence interval on this estimate of average profit? (1+1/2 point)
B. What is the estimate of the average profit if Fan sets the order quantity to 1,000? What is the 95% confidence interval on this estimate of average profit? ( 1 point)
C. Which order quantity should Fan choose based on the average profit? (1/2 points)

Categories
Excel

Discuss the number of waiting callers the expanded system would need to accommodate.

1. A detailed analysis of the operating characteristics of the reservation system with one agent as proposed by the vice president of administration. What is your recommendation concerning a single-agent system?
2. A detailed analysis of the operating characteristics of the reservation system based on your recommendation regarding the number of agents Regional should use.
3. A detailed analysis of the advantages or disadvantages of the expanded system. Discuss the number of waiting callers the expanded system would need to accommodate.
4. This report represents a pilot study of the reservation system for the 10:00 a.m. to 11:00 a.m. time period during which an average of one call arrives every 4.75 minutes; however, the arrival rate of incoming calls is expected to change from hour to hour. Describe how your waiting line analysis could be used to develop a ticket agent staffing plan that would enable the company to provide different levels of staffing for the ticket reservation system at different times during the day. Indicate the information that you would need to develop this staffing plan.
Please also upload an Excel file to show your analytics. In other words, you submit an Excel file and a Word file.

Categories
Excel

What is your recommendation concerning a single-agent system?

1. A detailed analysis of the operating characteristics of the reservation system with one agent as proposed by the vice president of administration. What is your recommendation concerning a single-agent system?
2. A detailed analysis of the operating characteristics of the reservation system based on your recommendation regarding the number of agents Regional should use.
3. A detailed analysis of the advantages or disadvantages of the expanded system. Discuss the number of waiting callers the expanded system would need to accommodate.
4. This report represents a pilot study of the reservation system for the 10:00 a.m. to 11:00 a.m. time period during which an average of one call arrives every 4.75 minutes; however, the arrival rate of incoming calls is expected to change from hour to hour. Describe how your waiting line analysis could be used to develop a ticket agent staffing plan that would enable the company to provide different levels of staffing for the ticket reservation system at different times during the day. Indicate the information that you would need to develop this staffing plan.
Please also upload an Excel file to show your analytics. In other words, you submit an Excel file and a Word file.

Categories
Excel

He downloaded data for his customers’ food and beverage purchases for the week.

Project Description:
Your friend Kimo is a server at a restaurant. He downloaded data for his customers’ food and beverage purchases for the week. You will complete the workbook by applying consistent formatting across the worksheets and finalizing the weekly summary. The restaurant requires tip sharing, so you will calculate how much he will share with the beverage worker and the assistant.

Categories
Excel

The restaurant requires tip sharing, so you will calculate how much he will share with the beverage worker and the assistant.

Project Description:
Your friend Kimo is a server at a restaurant. He downloaded data for his customers’ food and beverage purchases for the week. You will complete the workbook by applying consistent formatting across the worksheets and finalizing the weekly summary. The restaurant requires tip sharing, so you will calculate how much he will share with the beverage worker and the assistant.

Categories
Excel

Write up your results in a formal report to hatco management.

The Excel file HATCO consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO.
The following are the independent variables.
• Delivery Speed —amount of time it takes to deliver the product once an order is confirmed.
• Price Level —perceived level of price charged by product suppliers.
• Price Flexibility —perceived willingness of HATCO representatives to negotiate price on all types of purchases.
• Manufacturing Image —overall image of the manufacturer or supplier.
• Overall Service—overall level of service necessary for maintaining a satisfactory relationship between supplier and purchaser.
• Sales Force Image —overall image of the manufacturer’s sales force.
• Product Quality —perceived level of quality of a particular product.
• Size of Firm—size relative to others in this market (0 = small; 1 = large).
Responses to the first seven variables were obtained using a graphic rating scale, where a 10‐cm line was drawn between endpoints labeled “poor” and “excellent.”
Respondents indicated their perceptions using a mark on the line, which was measured from the left endpoint. The result was a scale from 0 to 10 rounded to one decimal place.
Using the tools in this chapter, conduct a complete analysis to predict Usage Level. Be sure to investigate the impact of the categorical variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions. Also stratify the data by firm size to account for any differences between small and large firms. Write up your results in a formal report to HATCO management.

Categories
Excel

Write up your results in a formal report to hatco management.

The Excel file HATCO consists of data related to predicting the level of business (Usage Level) obtained from a survey of purchasing managers of customers of an industrial supplier, HATCO.
The following are the independent variables.
• Delivery Speed —amount of time it takes to deliver the product once an order is confirmed.
• Price Level —perceived level of price charged by product suppliers.
• Price Flexibility —perceived willingness of HATCO representatives to negotiate price on all types of purchases.
• Manufacturing Image —overall image of the manufacturer or supplier.
• Overall Service—overall level of service necessary for maintaining a satisfactory relationship between supplier and purchaser.
• Sales Force Image —overall image of the manufacturer’s sales force.
• Product Quality —perceived level of quality of a particular product.
• Size of Firm—size relative to others in this market (0 = small; 1 = large).
Responses to the first seven variables were obtained using a graphic rating scale, where a 10‐cm line was drawn between endpoints labeled “poor” and “excellent.”
Respondents indicated their perceptions using a mark on the line, which was measured from the left endpoint. The result was a scale from 0 to 10 rounded to one decimal place.
Using the tools in this chapter, conduct a complete analysis to predict Usage Level. Be sure to investigate the impact of the categorical variable Size of Firm (coded as 0 for small firms and 1 for large firms) and possible interactions. Also stratify the data by firm size to account for any differences between small and large firms. Write up your results in a formal report to HATCO management.

Categories
Excel

C 12_directions _ anova.docx

The Anova Excel Data sheet is needed for this activity. Access the Excel sheet by clicking on the Class Survey Data File icon on the Home Page. You must use your sdsu.edu account to access. You must download the file to use the data.
There are 3 files: Follow the Directions (1) to complete the assignment using the Anova data from the Class Survey Data File (2), and submit your work using the Assignment Submission Form (3) via the appropriate link —
1. C 12_Directions _ Anova.docx
3. C 12_Assignment Submission Form_Anova.docx
Following the due date and time there is a 24-hour window to submit late submissions– no questions asked, no explanations needed — for partial credit, after which this assignment closes.

Categories
Excel

Knowledge.

OBJECTIVE: To do a project involving a CAAT that emulates the steps using the IT Audit Body of
Knowledge. In addition to these instructions, students will be provided an Excel Plug-in tool – Active
Data, as limited freeware.