St Leo MBA550 Project

Hello I’m inquiring to see of you can assist w/ my term project. Please see instructions below. Please let me know what the fee would be.

You are required to submit a written business report about the assigned exercise. This report is to provide all the details in the problem analysis and solution and provide a permanent, written example of the work you have done to solve the problem for the business. The report should consist of two parts, a Word document including the material below:
Problem statement
A discussion of model formulation and the computer solution
Evaluation and answers to the questions in the topic (if appropriate)

and the Excel spreadsheet file used to solve the model.

You will be required to prepare a Power Point presentation of adequate length to explain the problem, solution, and evaluation of the solution. Do not simply repeat the material in the written report and avoid too much detail but assume this is the key feature of your explanation of what your team has developed to solve the problem.

Delicious Foods Corporation

The Delicious Foods Corporation makes nutrition (candy) bars. Next month (January) the company plans to sell nearly 200,000 pounds of candy (although they don’t call it candy because they extol its nutritional value), which will be packaged as 600,000 bars; the price Delicious Foods will receive is 28 cents ($0.28) for each bar. Production capacity for the plant is 640,000 bars per month. The cost estimates for next month are:

Fixed Costs (do not vary with number of bars made)
Fixed manufacturing costs (factory overhead) $ 21,500
Fixed administrative costs (office overhead) 11,500
Advertising 4,500
Interest 4,100

Variable Costs (each of these is a “per bar” cost)
Labor 4 cents per bar
Materials 8 cents per bar

The planning horizon for Delicious Foods is the next five months, January thru
May. For January, the price will be $0.28 per bar; after that, the price will increase
to $0.29 for two months, and then to $0.30 for two months. The number of bars
made and sold is projected to begin at 600,000 bars, and then increase 2.5% each
month until the capacity of 640,000 bars is reached. Because of the rapid growth,
substantial increases in other costs are projected as follows:

Fixed manufacturing costs (factory overhead) increase 5% per month
Fixed administrative costs (office overhead) increase 7% per month
Advertising increase 8% per month
Interest will not change
Labor increase 10% per month
Materials increase 0.1 cents
($0.01) per bar each month

The General Manager (GM) is considering augmenting the advertising with a marketing cam¬paign designed to increase volume. This additional advertising would cost $7500 in January and $1500 in each of the remaining four months of the planning horizon. These campaign costs are in addition to the advertising costs already discussed. Once started, the marketing campaign must continue. The thrust of the campaign is to enhance the quantity of bars sold at the prices projected above. The GM believes that the campaign will either be a flop (leaving the quantity sold as projected), be moderately successful (bringing about an 8% monthly increase in quantity sold, instead of 2.5%), or be very successful (bring¬ing about a 15% monthly increase in quantity sold, instead of 2.5%). A decision to begin the campaign must be made within a day or two.
The campaign may not be a very good idea if the capacity limits (640,000 bars per month) are reached. Negotiations have taken place to obtain expanded facilities at the end of the first month, when it will be known if the advertising campaign is a flop, is moderately successful, or is very successful. The facilities expansion will cost $500 a month for the remaining four months, to increase capacity to 750,000 bars a month. Increasing the capacity to 1,000,000 bars a month would cost $1000 a month for the remaining four months. The capacity decision is made at the beginning of the second month; once made, it cannot be changed.
The probabilities of success for the campaign are flop, 0.1; moderate, 0.5; very successful, 0.4.

Analysis

What is the GM’s primary issue at this point? The first decision that must be made is whether to undertake the advertising campaign. There is a secondary issue facing the GM: whether to expand the capacity of the factory. While it is known that there is enough capacity for January (planned production: 600,000 bars; capacity: 640,000 bars), it may be advantageous to obtain more capacity. If the campaign is started, the decision to obtain more capacity can be made after the first month’s results are known. The GM believes that the growth rate in the first month will continue throughout the planning horizon. (Oh, how wordy that has become!) The purpose of the wordiness is to demonstrate vividly the ability of a decision tree to communicate the sequence of acts and events. Develop such a decision tree for the GM.
The scenario has provided the probability values, so they present no difficulty. The terminal values for profit will require substantial computation, however. A spreadsheet model is a useful way to calculate these terminal values. The model should calculate the profit before tax for any combination of campaign decision, campaign event (bar growth rate), and capacity decision. Rather than attempt to develop one model to simultaneously evaluate all end points, you should try to build one model that can be used to evaluate each end point by changing the values in a few cells.

Activities:

Write a report for the GM (and be prepared to present it).
a. Construct a spreadsheet model using the data provided.
b. Use the model to find all terminal values in the decision tree.
c. Construct the decision tree, placing probabilities on appropriate branches.
d. Use the tree to recommend a course of action.
e. What would be the end result (net income) if the worst possible set of events occurred? Discuss.
f. What would be the end result (net income) if the best possible set of events occurred? Discuss.

g.Which would be worse, to have a very successful ad campaign and not expand production or to have a poor ad campaign and expand production? (Assume you dont know the result of the campaign before you have to decide on expansion.) Why. Explain in detail.
h.At what cost for expanded capacity would expansion become infeasible? Explain.

Our guarantees

Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Get your paper done by an expert