YO25_Excel_Ch04_Express

Project Description:

Kimm Bearheart is the corporate buyer for vehicles put into service by Express Car Rental. Kimm has the option to buy several lots of vehicles from another rental agency that is downsizing, and wants to get a better idea of the number of rentals nationwide by vehicle type. The corporate accountant has forwarded Kimm a worksheet containing rental data for last year. Kimm wants to use this summarized data but feels that embedding charts will provide a quicker analysis in a more visual manner for the chief financial officer at their meeting next week.

Steps to Perform:

ONLY DO STEPS 2, 3, 4, 5, 6, 8 AND 9

Step	Instructions	Points Possible
1	Start Excel. Download and open the file named Excel_Ch04_Express.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.	0
2	Charting data is good way to analyze data visually. Use the cell ranges A5:A10 and O5:O10 on the AnnualData worksheet to create a 3-D Pie chart of the number of annual rentals for the six car types. Move the chart so the upper left corner is inside cell I12 and the lower right corner is in cell O26.	13
3	Having a descriptive chart title is important to understand the chart’s contents. On the 3-D pie chart, change the title to Annual Rentals Change the font of the title to Arial Black, 16 pt., and bold.	8
4	To make the pie chart more descriptive, data labels can be added. Add data labels on the pie chart to include the category name and percentage only. Position the label information on the outside end of the chart. Change the font size of the labels to 8 and apply bold. Because data labels were added, remove the chart legend.	8
5	Change the color palette of the 3-D pie chart to Monochromatic, Palette 1.	2
6	Explode the slice of the 3-D pie chart to 20% that represents the auto type with the lowest percentage of annual rentals. Change the Chart area to Turquoise, Accent 4, Lighter 80% fill.	6
7	Adjust the 3-D rotation of the chart to have the X rotation of 70 and a Y rotation of 50 Adjust the perspective to 10.	0
8	Click the clustered column chart located below the monthly data. Change the chart type of the chart to a Line chart.	2
9	Increase the data used in the line chart to include the months of July, August, and September. Switch the row and column data so that the months July to December are represented on the x-axis.	1
10	Format the appearance of the line chart with the following: Filter the chart to display only Green Collection, Compact/Midsize, and Full-size/Standard (Mac users can skip this step). Change the chart style to Style 6. Add primary major vertical gridlines. Change the chart title to July-December Rental Types	0
11	Create a 3-D Clustered Column chart using the cell ranges A5:A10 and H5:H10 for the Semi-Annual Total for all auto types on the AnnualData worksheet. The primary horizontal axis should be the auto types.	0
12	Change the chart title by creating a reference to cell H4 on the AnnualData worksheet.	0
13	Move the 3-D column chart from the AnnualData worksheet to a chart sheet, and then name that worksheet SemiAnnualReport	0
14	Add data labels to the chart. Change the font size of the data labels to 14 and then bold the data labels.	0
15	Change the color of the Chart Area to Turquoise, Accent 4, Lighter 80% fill.	0
16	Move the SemiAnnualReport worksheet to the right of the AnnualData worksheet.	0
17	Save and close Excel_Ch04_Express.xlsx. Exit Excel. Submit the file as directed.	0

Total Points

40

YO25_Excel_Ch04_Express

Project Description:

Kimm Bearheart is the corporate buyer for vehicles put into service by Express Car Rental. Kimm has the option to buy several lots of vehicles from another rental agency that is downsizing, and wants to get a better idea of the number of rentals nationwide by vehicle type. The corporate accountant has forwarded Kimm a worksheet containing rental data for last year. Kimm wants to use this summarized data but feels that embedding charts will provide a quicker analysis in a more visual manner for the chief financial officer at their meeting next week.

Steps to Perform: ONLY DO STEPS 2, 3, 4, 5, 6, 8 AND 9

Step	Instructions	Points Possible
1	Start Excel. Download and open the file named Excel_Ch04_Express.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.	0
2	Charting data is good way to analyze data visually. Use the cell ranges A5:A10 and O5:O10 on the AnnualData worksheet to create a 3-D Pie chart of the number of annual rentals for the six car types. Move the chart so the upper left corner is inside cell I12 and the lower right corner is in cell O26.	13
3	Having a descriptive chart title is important to understand the chart’s contents. On the 3-D pie chart, change the title to Annual Rentals Change the font of the title to Arial Black, 16 pt., and bold.	8
4	To make the pie chart more descriptive, data labels can be added. Add data labels on the pie chart to include the category name and percentage only. Position the label information on the outside end of the chart. Change the font size of the labels to 8 and apply bold. Because data labels were added, remove the chart legend.	8
5	Change the color palette of the 3-D pie chart to Monochromatic, Palette 1.	2
6	Explode the slice of the 3-D pie chart to 20% that represents the auto type with the lowest percentage of annual rentals. Change the Chart area to Turquoise, Accent 4, Lighter 80% fill.	6
7	Adjust the 3-D rotation of the chart to have the X rotation of 70 and a Y rotation of 50 Adjust the perspective to 10.	0
8	Click the clustered column chart located below the monthly data. Change the chart type of the chart to a Line chart.	2
9	Increase the data used in the line chart to include the months of July, August, and September. Switch the row and column data so that the months July to December are represented on the x-axis.	1
10	Format the appearance of the line chart with the following: Filter the chart to display only Green Collection, Compact/Midsize, and Full-size/Standard (Mac users can skip this step). Change the chart style to Style 6. Add primary major vertical gridlines. Change the chart title to July-December Rental Types	0
11	Create a 3-D Clustered Column chart using the cell ranges A5:A10 and H5:H10 for the Semi-Annual Total for all auto types on the AnnualData worksheet. The primary horizontal axis should be the auto types.	0
12	Change the chart title by creating a reference to cell H4 on the AnnualData worksheet.	0
13	Move the 3-D column chart from the AnnualData worksheet to a chart sheet, and then name that worksheet SemiAnnualReport	0
14	Add data labels to the chart. Change the font size of the data labels to 14 and then bold the data labels.	0
15	Change the color of the Chart Area to Turquoise, Accent 4, Lighter 80% fill.	0
16	Move the SemiAnnualReport worksheet to the right of the AnnualData worksheet.	0
17	Save and close Excel_Ch04_Express.xlsx. Exit Excel. Submit the file as directed.	0

Total Points

40

ict gagadgegadget

ict gagadgegadget

Outside Environment, Inc. provides commercial landscaping services in San Diego. Sasha Cairns, the

firm’s owner, wants to develop cost estimates that she can use to prepare bids on jobs. After analyzing

the firm’s costs, Cairns has developed the following preliminary cost estimates for each 1,000 square

feet of landscaping.

Cairns is quite certain about the estimates for direct material and direct labor. However, she is not as

comfortable with the overhead estimate. The estimate for overhead is based on the overhead costs that

were incurred during the past 12 months as presented in the following schedule. The estimate of $18

per direct-labor hour was determined by dividing the total overhead costs for the 12-month period

($1,296,000) by the total direct-labor hours (72,000).

Cairns believes that overhead is affected by total monthly direct-labor hours. Cairns decided to perform

a least-squares regression of overhead (OH) on total direct-labor hours (DLH).

Required:

1. Develop cost formula for overhead cost using least square regression method by constructing

excel spreadsheet.

2. The overhead rate developed from the least-squares regression is different from Cairns’

preliminary estimate of $18 per direct-labor hour. Explain the difference in the two overhead

rates.

3. Using the overhead formula that was derived from the least-squares regression, determine a

total variable-cost estimate for each 1,000 square feet of landscaping.

4. Cairns has been asked to submit a bid on a landscaping project for the city government

consisting of 50,000 square feet. Cairns estimates that 30 percent of the direct-labor hours

required for the project will be on overtime. Calculate the incremental costs that should be

included in any bid that Cairns would submit on this project. Us

Overview

Data measurement is an important aspect of data analytics. Identifying trends in key attributes of data is a fundamental measurement for various aspects of business data and an important skill for business professionals.

Scenario

You have been hired as a consultant by TC Ice Cream. As part of its expansion plan, TC Ice Cream wants to limit the number of flavors that they sell and only focus on those that are the most profitable. You will do an analysis of two flavors for a specific division and determine which flavor should be kept and which should be removed.

• Option A: Keep Flavor One
• Option B: Keep Flavor Two

The TC Ice Cream management team has tasked you with doing an in-depth analysis to determine which of the two options will be the most profitable, given the monthly advertising expense of $5,000. Use the division that you selected in Module Two and select two flavors to make your recommendation. Consider the TC Ice Cream data set that contains data about quantity sold, advertising expenses, flavor rating, social media posts, and event promotions.

• You will use the same division and the same two flavors throughout the remainder of the course.
• Keep in mind that the WEST NORTH CENTRAL division cannot be used for your analysis.

Your work here in Phase One is to do a current trend analysis, which will help you test your initial hypothesis as to which ice cream flavor has the most sales. You will use the work here as a foundation for Phase Two (in Milestone Two).

Once you have completed the visualizations for the two flavors you selected, you will create a PowerPoint presentation analyzing the data.

Prompt

For this assignment, you will analyze the data from the TC Ice Cream data set and identify trends and patterns. You will submit an analysis report in the form of a PowerPoint presentation. You will also create multiple charts to present the descriptive analysis you performed.

Within the , you will use the sheets Flavor One Analysis and Flavor Two Analysis to create your visualizations. Select two flavors within the division you selected in Module Two.

Complete the following visualizations for each flavor. The visualizations for Flavor One should be completed in the Flavor One Analysis sheet and the visualizations for Flavor Two should be completed in the Flavor Two Analysis sheet. It is recommended that you use pivot table filtering to filter the data to the specific division and flavor you have selected.

Specifically, you must address the following rubric criteria:

• Excel Workbook
  • Present the key descriptive statistics for the five quantitative variables in a table (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions). The key descriptive statistics include the mean, median, standard deviation, and range.
  • Analyze the TC Ice Cream data to identify trends and patterns for the two flavors you have selected. For each flavor, create the following visualizations.
    • Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month.
    • Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Flavor Rating (average) to provide a visualization displaying flavor rating (average) by year/quarter/month.
    • Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables: Quantity Sold (clustered column) and Advertising expenditures (line – secondary axis).
    • Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables: Quantity Sold (clustered column) and total Social Medial Posts and Event Promotions (line – secondary axis). Hint: create a pivot table variable to sum the social media posts and event promotions.
    • Create a box and whiskers chart using the qualitative variable Quantity Sold. This will help identify any outliers in the quantity sold data.
    • Create a histogram for the quantitative variable Flavor Rating. It is recommended to use the data analysis add-in and the analysis tool Histogram to create the data for the visualization.
• PowerPoint Presentation
  Using the Milestone One PowerPoint Template, complete the following:
  • Outliers: Identify any outliers that you see and explain how they have an impact on the overall trends. Outliers are the data points that can have an impact on your averages and basic descriptive analysis.
  • Analysis: Form and explain your initial hypothesis based on your analysis of the charts and trends in Excel.
    • Analyze the histogram of the flavor ratings for each flavor you selected.
    • Which option (Option A or Option B) would you choose at this point in your analysis, given the monthly expense of $5,000?
    • Why did you choose your selected attributes?
    • Describe any relationships or trends you observed while conducting your analysis.
    • Your presentation should include key visualizations and analysis to support your report.

What to Submit

• TC Ice Cream Excel Workbook: Submit the . For this assignment, work should be completed in the Flavor One Analysis and Flavor Two Analysis sheets. Do not remove any sheets from the workbook.
• PowerPoint Presentation: Submit a PowerPoint presentation using the . Any sources should be cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.

Milestone One Rubric

Criteria	Exceeds Expectations (100%)	Meets Expectations (90%)	Partially Meets Expectations (70%)	Does Not Meet Expectations (0%)	Value
Descriptive Statistics	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Presents descriptive statistics for the five quantitative variables (mean, median, standard deviation, and range) with no errors or omissions for the two flavors selected	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include presenting error-free statistics or omitting critical data	Does not attempt criterion	20
Flavor One Trends and Visualizations	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Creates six visualizations for Flavor One to identify trends	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating more charts, trends, and so on, using the data variables with minimal errors or omissions	Does not attempt criterion	15
Flavor Two Trends and Visualizations	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Creates six visualizations for Flavor Two to identify trends	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating more charts, trends, and so on, using the data variables with minimal errors or omissions	Does not attempt criterion	15
PowerPoint: Outliers	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Identifies specific outliers in the data and describes how specific outliers impact the descriptive analysis	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include highlighting specific outliers and their impact on charts or trends	Does not attempt criterion	20
PowerPoint: Analysis	Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner	Explains the analysis in a clear and detailed manner and provides data and visualizations to support analysis	Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include ensuring the analysis includes specific mention of data points, outliers, and trends that connect strongly with Excel analysis	Does not attempt criterion	20
Clear Communication	Exceeds expectations with an intentional use of language that promotes a thorough understanding	Consistently and effectively communicates in an organized way to a specific audience	Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding	Shows no evidence of consistent, effective, or organized communication	10
Total:					100%

Attached Files (PDF/DOCX): Project for reference.docx

Note: Content extraction from these files is restricted, please review them manually.

Please check the attachment(do not use PI)

Growing a business

growing a business requires clear planning, smart execution, and continuous improvement. Whether you are starting a small shop or building a large company, business growth depends on understanding your customers, improving your product or service, and using effective marketing strategies.

First, you must understand your target market. A business cannot grow if it does not know who its customers are. Research your audiences needs, preferences, and problems. For example, companies like Amazon became successful because they focused strongly on customer satisfaction. They studied customer behavior and made shopping easier with fast delivery, simple returns, and personalized recommendations. When you understand your customers well, you can offer solutions that truly meet their needs.

Second, focus on providing high-quality products or services. Quality builds trust, and trust creates repeat customers. If customers are happy, they will recommend your business to others. For instance, Apple has grown worldwide because of its focus on design, innovation, and product quality. Even though their products can be expensive, customers are willing to pay because they trust the brand. This shows that quality can be more important than low prices.

Third, create a strong marketing strategy. Marketing helps people know about your business. Today, digital marketing is very powerful. Social media platforms, websites, and email marketing allow businesses to reach a large audience at low cost. For example, Nike uses powerful advertising campaigns and social media to connect emotionally with customers. Their marketing tells inspiring stories, which builds strong brand loyalty. Small businesses can also use social media platforms like Instagram or Facebook to promote their products and interact directly with customers.

Another important factor in business growth is financial management. You must track your income and expenses carefully. Poor financial planning can cause even profitable businesses to fail. Always reinvest part of your profits back into the business. This could mean upgrading equipment, hiring skilled employees, or expanding to new locations.

Innovation is also key to long-term growth. Markets change quickly, and businesses must adapt. For example, Netflix started as a DVD rental company but later shifted to online streaming when technology changed. This smart decision helped the company grow globally. If Netflix had refused to change, it might not exist today. Business owners must always look for new trends and opportunities.

Customer service plays a major role as well. Good customer service builds loyalty and positive word-of-mouth. Respond to complaints quickly and politely. Show customers that you value them. A loyal customer base provides stable income and supports business expansion.

Finally, build a strong team. Employees are the backbone of any successful business. Hire people who share your vision and motivate them with training and fair rewards. A motivated team works harder and contributes new ideas for growth.

In conclusion, growing a business requires understanding customers, offering quality products, effective marketing, good financial management, innovation, excellent customer service, and a strong team. Companies like Amazon, Apple, Nike, and Netflix demonstrate that focusing on customers and adapting to change can lead to long-term success. With dedication, planning, and continuous improvement, any business can achieve steady growth.