University : Victoria University UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : RCM2911
Country : Australia

Assignment Task

Task

A real estate agent is fixing up a house for sale. She is deciding between painting, or new carpet, or both. Some analysis indicates that every square metre of new painting is worth $200 profit in sales, and every square metre of new carpet is worth $250 in sale profit. Painting costs $15 for each square metre, and takes half an hour; carpeting costs $25 for each square metre and takes a quarter of an hour. She has only $700 to spend, and only 14 hours available. And she wants to maximise her total sales profits.

  1. Set up a resources table showing all information, costs, available resources, and sales profits.

  2. Draw the feasible region, and determine the values of all vertices.

  3. Solve the above problem using your diagram.

  4. Also solve it using Excel Solver (include screenshots in your assignment, or upload the spreadsheet to the Dropbox), including the sensitivity analysis.

  5. Determine the shadow price of each constraint by a graphical method and check the answers obtained by Excel.

  6. Find the ranges of the profits for each of painting and carpeting, which does not affect the optimum value, by a graphical method.

 

This RCM2911Accounting and Finance Assignment Help has been solved by our Accounting and Finance Experts at Unilearno. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Brayden
  • Posted on : January 06th, 2024

Whatsapp Tap to ChatGet instant assistance