Mr. Palsson Finance Assingment Help With Solution
Mr. Palsson is an MBA candidate who is considering his life choices. He has spent the past year and a half preparing for a career in consulting and has recently landed a job with a respectable firm with a annual starting salary of $83,000. Although quite satisfied with the offer, he is also considering starting a restaurant. He has always had passion for food, and believes he can start a new restaurant to compete for the lunch crowd in Downtown College Park, given the poor food choices available.
In particular, he has built a business plan for the restaurant. He has figured that rent, utilities and other unavoidable costs will be $4,000 a month. Variable costs will mostly consist of labor costs, which he expects to be uniformly distributed between $5,000 and $7,000, and raw material costs that depend on the number of prepared meals.
Depending on the interest in the lunches, he estimates he can set the price per lunch somewhere between $15 and $20, and still have a healthy volume of 3,000 meals served per month. Although his price calculations are based on a volume of 3,000 he also acknowledges that there will be some variation around his estimate, in particular he models the volume as a normal distribution with a standard deviation of a 1,000. His estimated probabilities for the success of the lunch place and the associated prices are summarized in Exhibit 1. The lunch meals, will be higher quality lunches, and he estimates the raw material will be $11 on average.
The restaurant business is a risky business and his well off aunt has offered to partner up with him. In particular she has offered to guarantee a minimum salary of $3,500 a month, but instead if the monthly profit is greater than $9,000, she receives 90% of every dollar in profit above the $9,000 mark.
Interest level Price per Meal Probability
Great $ 20.00 20%
Good $ 18.50 35%
Medium $ 16.50 30%
Low $ 15.00 15%
Exhibit 1: Price and Interest Level Scenarios
How it Works
How It works ?
Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.
Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.
Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.
Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.
Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.
Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.
Features
Features for Assignment Help
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.
All our works are kept as confidential as we respect the integrity and privacy of our clients.
Related Services
- Physics Assignment Help
- Chemistry Assignment Help
- Engineering Assignment Help
- Psychology Assignment Help
- Online exam Help
- Marketing Assignment Help
- Arts Assignment Help
- Sociology Assignment Help
- Project Management Assignment
- Case Study Help
- Nursing Assignment Help
- Research Assignment Help
- Operations Management Assignment help
- Accounting Assignment Help
- Biology Assignment Help
- Mathematics Assignment Help
- English Assignment Help
- Business Plan Help
- Essay Writing Help
- Human Resource Assignment Help
- Accounting Homework Help
- Computer Science Assignment Help
- Finance Assignment Help
- Economics Assignment Help
- Statistics Homework Help
- Management Assignment Help
- Strategy Management Assignment Help
- Auditing Assignment Help
- Information Management Assignment Help
- Online Assignment Writing help
- Best Assignment Help
- Humanities Assignment help
- Corporate Finance Assignment help
- Financial Management Assignment Help
- Supply Chain Management Assignment Help
- Taxation Homework Help
- MBA operations management assignment help
- History Assignment help
- Geography Assignment Help
- Anthropology Assignment help
- Archaeology Assignment help
- Counselling assignment help
- Criminology assignment help
- Linguistics Assignment Help
- Architecture Assignment Help
- Philosophy Assignment Help
- Physics and Astronomy Assignment Help
- Physiotherapy Assignment Help
- Politics Assignment Help
Assumptions:
• You may ignore all tax considerations. If you choose to model them be specific about the assumptions you make
• For simplicity, assume that profit=Mr. Palsson’s salary.
• You may ignore any long-term considerations (such as long term personal growth, etc) and focus your analysis on the monthly level
The task:
a) Build an Excel model that calculates the expected profit for Mr. Palsson in a particular month if he undertakes the venture on his own, when the interest in the restaurant is at the medium level, and the variable cost is set at the expected value.
Include Exhibit 3-1 of your model that shows formulas and row and column headings. What is the profit for Mr. Palsson in this scenario?
b) Extend the model to include both profit calculations when Mr. Palsson enters the restaurant business on his own as well as when he partners up with his aunt.
Convert your static model to a simulation model by specifying appropriate probability distributions for uncertain inputs using @Risk functionality. Then, run the simulation for both scenarios (without and with support from the aunt) and answer the following questions based on your results:
o What is the expected profit per month when Mr. Palsson starts the business on his own?
o What is the probability that he makes more than $6,667 a month?
o What is the probability that he makes more than $10,000 a month?
o What is the expected profit when Mr. Palsson enters a partnership with his aunt?
o What is the probability that he makes more than $6,667 a month?
o What is the probability that he makes more than $10,000 a month?
Include an Exhibit 3-2 of your updated model, be sure to show formulas and include row and column headings.
Provide a histogram of the profit (salary) under partnership and label it as Exhibit 3-3. How would you (briefly) explain the shape of the histogram.
c) What would you recommend Mr. Palsson do (200 words max)? Include any additional Exhibits to support your answers as Exhibit 3-extra.
Product Code :Fin386
To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)
You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.