Performance lawn equipment report | Management homework help

Uncategorized

Module 7, Performance Lawn Equipment

Due Date:

Friday, December 3, 2021 at 9:00 PM

—————————————

Dear International Data Analytics for Business Executives:

Please read the following Data Analytics for Business case assigned for this Learning Module and please analyze and answer the Assignment(s) requested in this Case Analysis.

Assignments:

The worksheet Purchasing Survey in the Performance Lawn Care database provides data related to predicting the level of business (Usage Level) obtained from a third-party survey of purchasing managers of customers Performance Lawn Care.

The seven PLE attributes rated by each respondent are

The data and description of this case are based on the HATCO example on pages 28–29 in Joseph F. Hair, Jr., Rolph E. Anderson, Ronald L. Tatham, and William C. Black, Multivariate Analysis, 5th ed. (Upper Saddle River, NJ: Prentice Hall, 1998).

Delivery speed —the amount of time it takes to deliver the product once an order is confirmed
Price level —the perceived level of price charged by PLE
Price flexibility —the perceived willingness of PLE representatives to negotiate price on all types of purchases
Manufacturing image —the overall image of the manufacturer
Overall service —the overall level of service necessary for maintaining a satisfactory relationship between PLE and the purchaser
Sales force image —the overall image of the PLE’s sales force
Product quality —perceived level of quality

Responses to these seven variables were obtained using a graphic rating scale, where a 10-centimeter 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.

Two measures were obtained that reflected the outcomes of the respondent’s purchase relationships with PLE:

Usage level —how much of the firm’s total product is purchased from PLE, measured on a 100-point scale, ranging from 0% to 100%
Satisfaction level —how satisfied the purchaser is with past purchases from PLE, measured on the same graphic rating scale as perceptions 1 through 7

The data also include four characteristics of the responding firms:

Size of firm —size relative to others in this market (0=small;1=large)(0=small;1=large)
Purchasing structure —the purchasing method used in a particular company (1=centralized procurement,0=decentralized procurement)(1=centralized procurement,0=decentralized procurement)
Industry —the industry classification of the purchaser [1=retail(resale such as Home Depot),0=private(nonresale, such as a landscaper)][1=retail(resale such as Home Depot),0=private(nonresale, such as a landscaper)]
Buying type —a variable that has three categories (1=new purchase,2=modified rebuy,3=straight rebuy)(1=new purchase,2=modified rebuy,3=straight rebuy)

Assignment 1:

Elizabeth Burke would like to understand what she learned from these data.
Apply appropriate data-mining techniques to analyze the data. For example, can PLE segment customers into groups with similar perceptions about the company?

Can cause-and-effect models provide insight about the drivers of satisfaction and usage level? Summarize your results in a report to Ms. Burke.

Assignment 2:

The Performance Lawn Equipment database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing business, and this is accounted for as the selling expense. The tax rate is 50%.

Develop an Excel worksheet to extract and summarize the data needed to develop the income statement for 2014 and implement an Excel model in the form of a pro forma income statement for the company.

Assignment 3:

The CFO of Performance Lawn Equipment, J. Kenneth Valentine, would like to have a model to predict the net income for the next 3 years. To do this, you need to determine how the variables in the pro forma income statement will likely change in the future.

Using the calculations and worksheet that you developed along with other historical data in the database, estimate the annual rate of change in sales revenue, cost of goods sold, operating expense, and interest expense.

Use these rates to modify the pro Forma income statement to predict the net income over the next 3 years.

Because the estimates you derived from the historical data may not hold in the future, conduct appropriate what-if, scenario, and/or parametric sensitivity analyses to investigate how the projections might change if these assumptions don’t hold.

Construct a tornado chart to show how the assumptions impact the net income in your model.

Summarize your results and conclusions in a report to Mr. Valentine.

Assignment 4:

One of PLE’s manufacturing facilities produces metal engine housings from sheet metal for both mowers and tractors. Production of each product consists of five steps: stamping, drilling, assembly, painting, and packaging to ship to its final assembly plant.

The production rates in hours per unit and the number of production hours available in each department are given in the following table:

Department | Mower Housings | Tractor Housings| Production Hours Available

Stamping 0.03 0.07 200

Drilling 0.09 0.06 300

Assembly 0.15 0.10 300

Painting 0.04 0.06 220

Packaging 0.02 0.04 100

In addition, mower housings require 1.2 square feet of sheet metal per unit and tractor housings require 1.8 square feet per unit, and 2,500 square feet of sheet metal is available.

The company would like to maximize the total number of housings they can produce during the planning period.

Formulate and solve a linear optimization model and recommend a production plan.

Illustrate the results visually to help explain them in a presentation to Ms. Burke. In addition, conduct whatever what-if analyses (e.g., run different scenarios and apply parameter analysis) you feel are appropriate to include in your presentation.

Summarize your results in a well-written report.

An important aspect of business analytics is good communication. Summarize your findings and write up your answers to this case formally in a well-written report as

if you were a consultant to Ms. Burke USING our class:

Please develop YOUR OWN TEAM Business Data Analytics EXCEL model(s) to support all your answers and analyses and post this(these) file(s) in addition to your Case Analysis Performance Lawn Equipment Report.

Finally, please answer ALL Questions and Sections of this Data Analytics for Business Case with great detail AND STEP BY STEP being extremely methodical and accurate in your answers. It is extremely important that for each Question and Section, you write the entire question and you LABEL and/or PLACE the appropriate headings and subheadings clearly for EACH part of the question and/or section.

Please address, analyze, and discuss in great detail and thoroughly support and explain the what’s, how’s, and why’s of each of your answers.

I expect high caliber Case Analysis Reports with top analyses and interesting insights!! If you have any questions, please let me know. I am here to help.

In addition, mower housings require 1.2 square feet of sheet metal per unit and tractor housings require 1.8 square feet per unit, and 2,500 square feet of sheet metal is available.

The company would like to maximize the total number of housings they can produce during the planning period.

Formulate and solve a linear optimization model and recommend a production plan.

Summarize your results in a well-written report.

An important aspect of business analytics is good communication. Summarize your findings and write up your answers to this case formally in a well-written report as

if you were a consultant to Ms. Burke USING our class:

——————————————————————————————————————————-

Please address, analyze, and discuss in great detail and thoroughly support and explain the what’s, how’s, and why’s of each of your answers.

I expect high caliber Case Analysis Reports with top analyses and interesting insights!! If you have any questions, please let me know. I am here to help.

Continue to order Get a quote

July 1, 2023

Q1. Elizabeth Bishop worked as a painter as well as a poet, and her verse, like visual art, is known for its ability to capture significant scenes. Explain how “Filling Station” relies heavily on visual images. Also, a filling station is a very humble and unglamorous subject for a poem. Comment on the poet’s choice of subject. What other artist could you compare to Bishop with regard to choosing mundane subjects?

(Filling Station by Elizabeth Bishop)

Oh, but it is dirty!

—this little filling station,

oil-soaked, oil-permeated

to a disturbing, over-all

black translucency.

Be careful with that match!

Father wears a dirty,

oil-soaked monkey suit

that cuts him under the arms,

and several quick and saucy

and greasy sons assist him

(it’s a family filling station),

all quite thoroughly dirty.

Do they live in the station?

It has a cement porch

behind the pumps, and on it

a set of crushed and grease-

impregnated wickerwork;

on the wicker sofa

a dirty dog, quite comfy.

Some comic books provide

the only note of color—

of certain color. They lie

upon a big dim doily

draping a taboret

(part of the set), beside

a big hirsute begonia.

Why the extraneous plant?

Why the taboret?

Why, oh why, the doily?

(Embroidered in daisy stitch

with marguerites, I think,

and heavy with gray crochet.)

Somebody embroidered the doily.

Somebody waters the plant,

or oils it, maybe. Somebody

arranges the rows of cans

so that they softly say:

esso—so—so—so

to high-strung automobiles.

Somebody loves us all.

Q2. William Wordsworth’s poem “I Wandered Lonely as a Cloud” celebrates nature, but in a way very different from “There Will Come Soft Rains.” Compare and contrast these poems.

(I Wandered Lonely as a Cloud by William Wordsworth)

I WANDERED lonely as a cloud

That floats on high o'er vales and hills,

When all at once I saw a crowd,

A host, of golden daffodils;

Beside the lake, beneath the trees,

Fluttering and dancing in the breeze.

Continuous as the stars that shine

And twinkle on the milky way,

They stretched in never-ending line

Along the margin of a bay:

Ten thousand saw I at a glance,

Tossing their heads in sprightly dance.

The waves beside them danced; but they

Out-did the sparkling waves in glee:

A poet could not but be gay,

In such a jocund company:

I gazed--and gazed--but little thought

What wealth the show to me had brought:

For oft, when on my couch I lie

In vacant or in pensive mood,

They flash upon that inward eye

Which is the bliss of solitude;

And then my heart with pleasure fills,

And dances with the daffodils.

(There Will Come Soft Rains by Sara Teasdale)

There will come soft rains and the smell of the ground,

And swallows circling with their shimmering sound;

And frogs in the pools singing at night,

And wild plum trees in tremulous white;

Robins will wear their feathery fire,

Whistling their whims on a low fence-wire;

And not one will know of the war, not one

Will care at last when it is done.

Not one would mind, neither bird nor tree,

If mankind perished utterly;

And Spring herself, when she woke at dawn

Would scarcely know that we were gone.

July 1, 2023

(Filling Station by Elizabeth Bishop)

Oh, but it is dirty!

—this little filling station,

oil-soaked, oil-permeated

to a disturbing, over-all

black translucency.

Be careful with that match!

Father wears a dirty,

oil-soaked monkey suit

that cuts him under the arms,

and several quick and saucy

and greasy sons assist him

(it’s a family filling station),

all quite thoroughly dirty.

Do they live in the station?

It has a cement porch

behind the pumps, and on it

a set of crushed and grease-

impregnated wickerwork;

on the wicker sofa

a dirty dog, quite comfy.

Some comic books provide

the only note of color—

of certain color. They lie

upon a big dim doily

draping a taboret

(part of the set), beside

a big hirsute begonia.

Why the extraneous plant?

Why the taboret?

Why, oh why, the doily?

(Embroidered in daisy stitch

with marguerites, I think,

and heavy with gray crochet.)

Somebody embroidered the doily.

Somebody waters the plant,

or oils it, maybe. Somebody

arranges the rows of cans

so that they softly say:

esso—so—so—so

to high-strung automobiles.

Somebody loves us all.

Q2. William Wordsworth’s poem “I Wandered Lonely as a Cloud” celebrates nature, but in a way very different from “There Will Come Soft Rains.” Compare and contrast these poems.

(I Wandered Lonely as a Cloud by William Wordsworth)

I WANDERED lonely as a cloud

That floats on high o'er vales and hills,

When all at once I saw a crowd,

A host, of golden daffodils;

Beside the lake, beneath the trees,

Fluttering and dancing in the breeze.

Continuous as the stars that shine

And twinkle on the milky way,

They stretched in never-ending line

Along the margin of a bay:

Ten thousand saw I at a glance,

Tossing their heads in sprightly dance.

The waves beside them danced; but they

Out-did the sparkling waves in glee:

A poet could not but be gay,

In such a jocund company:

I gazed--and gazed--but little thought

What wealth the show to me had brought:

For oft, when on my couch I lie

In vacant or in pensive mood,

They flash upon that inward eye

Which is the bliss of solitude;

And then my heart with pleasure fills,

And dances with the daffodils.

(There Will Come Soft Rains by Sara Teasdale)

There will come soft rains and the smell of the ground,

And swallows circling with their shimmering sound;

And frogs in the pools singing at night,

And wild plum trees in tremulous white;

Robins will wear their feathery fire,

Whistling their whims on a low fence-wire;

And not one will know of the war, not one

Will care at last when it is done.

Not one would mind, neither bird nor tree,

If mankind perished utterly;

And Spring herself, when she woke at dawn

Would scarcely know that we were gone.

July 1, 2023

(Filling Station by Elizabeth Bishop)

Oh, but it is dirty!

—this little filling station,

oil-soaked, oil-permeated

to a disturbing, over-all

black translucency.

Be careful with that match!

Father wears a dirty,

oil-soaked monkey suit

that cuts him under the arms,

and several quick and saucy

and greasy sons assist him

(it’s a family filling station),

all quite thoroughly dirty.

Do they live in the station?

It has a cement porch

behind the pumps, and on it

a set of crushed and grease-

impregnated wickerwork;

on the wicker sofa

a dirty dog, quite comfy.

Some comic books provide

the only note of color—

of certain color. They lie

upon a big dim doily

draping a taboret

(part of the set), beside

a big hirsute begonia.

Why the extraneous plant?

Why the taboret?

Why, oh why, the doily?

(Embroidered in daisy stitch

with marguerites, I think,

and heavy with gray crochet.)

Somebody embroidered the doily.

Somebody waters the plant,

or oils it, maybe. Somebody

arranges the rows of cans

so that they softly say:

esso—so—so—so

to high-strung automobiles.

Somebody loves us all.

Q2. William Wordsworth’s poem “I Wandered Lonely as a Cloud” celebrates nature, but in a way very different from “There Will Come Soft Rains.” Compare and contrast these poems.

(I Wandered Lonely as a Cloud by William Wordsworth)

I WANDERED lonely as a cloud

That floats on high o'er vales and hills,

When all at once I saw a crowd,

A host, of golden daffodils;

Beside the lake, beneath the trees,

Fluttering and dancing in the breeze.

Continuous as the stars that shine

And twinkle on the milky way,

They stretched in never-ending line

Along the margin of a bay:

Ten thousand saw I at a glance,

Tossing their heads in sprightly dance.

The waves beside them danced; but they

Out-did the sparkling waves in glee:

A poet could not but be gay,

In such a jocund company:

I gazed--and gazed--but little thought

What wealth the show to me had brought:

For oft, when on my couch I lie

In vacant or in pensive mood,

They flash upon that inward eye

Which is the bliss of solitude;

And then my heart with pleasure fills,

And dances with the daffodils.

(There Will Come Soft Rains by Sara Teasdale)

There will come soft rains and the smell of the ground,

And swallows circling with their shimmering sound;

And frogs in the pools singing at night,

And wild plum trees in tremulous white;

Robins will wear their feathery fire,

Whistling their whims on a low fence-wire;

And not one will know of the war, not one

Will care at last when it is done.

Not one would mind, neither bird nor tree,

If mankind perished utterly;

And Spring herself, when she woke at dawn

Would scarcely know that we were gone.

Essay (any type)

August 22, 2022

They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.

Case study

August 22, 2022

Completed quickly and followed instructions given. Grammar, spelling, etc. was all good as well. Thank you so much! Will hire in the future.

Presentation/PPT

August 22, 2022

The work has not been graded but I like the output that was submitted to me. Is it possible for the same prof to do the next assignment I will be submitting? If possible, I will greatly appreciate it.

Journal article

August 22, 2022

My third using this writer and absolutely amazing work! Very punctual and very understanding.

Article

August 22, 2022

Outstanding job in writing my paper. I am always thrill to receive a well written paper that follows the instructions and the thorough details put into my paper. The quality of this paper is beyond awesome. Thank you so much.

Thesis/Thesis chapter

August 22, 2022

I absolutely love this writer! He/she always cranks out a fabulous paper and follows the assignment guidelines/instructions perfectly. Thanks again for always providing such quality work!!!

Research paper

August 22, 2022

It took some time to achieve the product I was looking for, but we eventually got there. I do feel like a lot of hard work was put into this, and it even exceeded the page requirement. I'm pretty pleased overall. I give my thanks.

Lab Report

August 22, 2022

Outstanding work! This writer followed every instruction and my paper came back with an A! I recommend to anyone needing help! Thank you again ❤️

Outline

August 22, 2022

Essay (any type)

August 22, 2022

Made 100% on both the outline and the paper. Quick turnaround time and my writer responded within 30 min or less. Any edits my instructor needed, my writer was patient and worked diligently to accomplish the task. Would recommend my writer to anyone!

Essay (any type)

August 5, 2021

You are making my life so much easier! I am a single mom that works and goes to school. You guys are helping me with my projects so I can have more free time with my son.

Annotated Bibliography

August 5, 2021

I was sure it can fit in a single page but the next time I will add one more page because I am impressed with your professionalism and quality. Will use many more times till I graduate.

Essay (any type)

August 5, 2021

Simple registration and quality services. I just ordered one paper, and it was good enough to pass the exam. That is what I need the most. Good job.

Research Proposal

August 5, 2021

I couldn’t finish my freaking essay, and I was very desperate. A friend of mine sent me a link, and that is how I found out about you guys. Thank you for professional tips and editing. Now, I understand how to write it properly.

Reflection

August 5, 2021

I’m so grateful to you since you managed to complete my term paper in one day! You are definitely the best company ever!

Essay (any type)

August 5, 2021

I am sure on your ability to provide any type of paper I will order. I wish I could develop that skill your writers have to be able to have a flow of ideas and excellent sequencing of thoughts in writing.

Coursework

August 5, 2021

I ordered a thesis paper and was satisfied. All the guys were polite and highly professional, even when I wrote to them several times per day. Thanks for your passion!

Discussion Essay

August 5, 2021

I turned to the service twice, and my papers always were beyond the expectations. To tell the truth, I was ready to find some grammar errors or something like that. However, everything was neat and tidy.

August 5, 2021

My friend recommended Doctor My Essay to me. It is convenient! Now we both turn to the service periodically coz wanna save some time and use it more effectively. I know that while I’m developing my startup, an expert is working on paper. Time management in work!

Research Paper

August 5, 2021

I write all paper works by myself but have some problems with literacy. Actually, I have enormous problems because English is not my native language. However, with proofreading from Doctor My Essay, I can relax and don’t be ashamed of mistakes.

Argumentative Essay

August 5, 2021

Your ability to write concisely is a finding. The paper has a solid argument. It’s clear that the writer understood central claim about the topic. He also presented original ideas to consider.

Coursework

August 5, 2021

That paper got the highest grade in my class and the professor thinks I’m the smartest student. Lol.

Essay (any type)

August 5, 2021

I was convinced that paper writing services are the fiction for naive students. But when it came to my research paper that was to be composed in 72 hours, I had no other options. I made the right choice when I ordered it from you!

Business Plan

August 5, 2021

I was also satisfied with the service. Usually, I write everything by myself, but this time ( I have no idea how it happens!) I missed the deadline. My writer was very responsible, wrote the essay quickly, and kept the instructions. Nice to know that such experts exist!

Annotated Bibliography

August 5, 2021

It is really affordable! The prices start from 9$, which is an excellent proposal on the market. Recently I worked with another service that took much more money and provided lower quality papers.

Research proposal

August 5, 2021

I am absolutely satisfied. I am first timer here. Revision was made quickly, and the author met my expectations. Thanks a lot. Paper is phenomenal.

Essay (any type)

August 5, 2021

Having heard a lot of negative reviews about such services, I was a bit skeptical. However, our cooperation with Doctor My Essay was without pitfalls. I made two comments about the final work, and they re-wrote some parts very promptly. I am satisfied and will turn to them in the future.

Research paper

August 5, 2021

It was my first experience in online ordering, and I was a bit nervous. However, this was for nothing. I’ve got a high mark!

Dissertation

August 5, 2021

I understand that buying essays is a doubtful thing. You don’t put effort, don’t represent your ideas… However, I don’t perceive Doctor My Essay as a standard service. They don’t sell papers. They share high expertise!

Coursework

August 5, 2021

According to my previous experience, this service is really the best. They support the client and have competitive writers. I give them a perfect score!

Admission Essay

August 5, 2021

Nice service! It is cool that you can use the calculator on the main page and understand the price policy. For me, it is a huge plus!

Discussion Essay

August 5, 2021

Thanks to God I found this service! If I didn’t send my research to the teacher on time, he would eat me. I tell you! However, with doctor my essay service, I met the deadline, and I am still alive.

Report

August 5, 2021

Your service is excellent! Convenient and not expensive. Thanks for that!

Essay (any type)

August 5, 2021

If you have problems with time management, just like me, you need to cooperate with Doctor My Essay. Once you registered and made the order, you understand how easier it makes your life! Everything is online: ordering, communication… You can control the process everywhere and be sure that an expert will provide a high-level paper.

Performance lawn equipment report | Management homework help

Calculate the price of your order

Our guarantees

Money-back guarantee

Zero-plagiarism guarantee

Free-revision policy

Privacy policy

Fair-cooperation guarantee