BUSS 3087 – Managing Decision Making Supplementary Assessment Part 1 – Complete the Spreadsheet Model The MS Excel file you have been sent is a partially completed version of what you were required to...

1 answer below »

BUSS 3087 – Managing Decision Making


Supplementary Assessment



Part 1 – Complete the Spreadsheet Model



The MS Excel file you have been sent is a partially completed version of what you were required to complete for your group model. Based on the business requirements listed below, complete the spreadsheet to comply with both the business’ needs and the guidelines for good spreadsheet design.


Some of the data has changed from the case study. Do NOT change any of the data in this model – just complete as per the requirements below.


Please do not change the file name or ANY of the data. You must then submit your completed spreadsheet together with this word document to the “Supplementary Assessment” submission area at the top of the BUSS 3087 learnonline page.



https://lo.unisa.edu.au/course/view.php?id=16001



Business Requirements for Spreadsheet Model


You have been asked to take over from an unproductive team to complete the business decision model spreadsheet so that the management team can use it to assist in their decision making around the renovations to the Old Calumet Inn. The team has advised that the following areas still need to be completed:




  • Input Page:




    • Data validation rules need to be set for each input field. This must include an input message, appropriate range for the data to be entered and an appropriate error message. (There are a couple already completed to help with this task).






  • Guest Room Calculations:




    • All of the data required for the calculations below is available on the Data Guest Room Upgrade sheet and the input sheet.




    • Calculate the guest room income per week for each room type and an overall total




    • Calculate the total cost of each type of mattress required for each of the 3 contractors and the overall total cost of mattresses, including delivery, for each contractor




    • Calculate the total number of sheet sets required to be purchased for each bed size and overall for each contractor






  • Wages Calculations:




    • All of the data required for the calculations below is available on the Wages Data sheet




    • Calculate the weekly wages for each of the employee types listed (there are a couple of calculations already completed that are correct)






  • Calculations:




    • Complete all calculations required on this sheet. A couple have already been done.




    • Some will be just direct cell reference to the other calculations or data sheets whilst some require further calculations using data from the data and input sheets.






  • Output




    • Link totals for each upgrade from calculations sheet to output sheet




    • Calculation totals for each contractor




    • Include a 2D stacked column chart which compares each contractor without including the total. Place the chart immediately below the Quotation Comparison




    • Complete the budget and calculate the number of weeks until profitable for each of the contractors






  • Documentation




    • Complete the documentation that has been started by the previous developers








Part 2 – Answer the following three questions from your understanding of the theory of the course.



Q1 – Decision Style and Personality.



During the course you were introduced to the impact that a person’s decision style and personality can have on the decision-making process. Using your decision style and personality results, and

research from at least 3 academic journal articles
, discuss the impact that these features have on your decision-making process.




Q2 – Teamwork



Your major assessment was a team based one. Describe, in detail, the team development activities that your team should have implemented and list a series of steps that you will personally take in your next team-based assessment to ensure a more successful team project. (Note: you should NOT include any negative discussion of other team members, this is strictly about what you SHOULD have done.) Include information from

at least one academic source not included in your course readings
.





Q3 – Decision Support Systems



Your team developed a spreadsheet model based on the Old Calumet Inn case study information. Please explain, in as much detail as possible, how the spreadsheet model acts as a DSS for the Old Calumet Inn and how it will aid their decision-making process. How does your spreadsheet model compare to the components of a DSS?

Use at least 3 academic journal articles to support your answer.

xiyzy002supplementary-assessment-mdm-model-for-wvxlf2xg.xlsx
Answered Same DayJul 16, 2021BUSS 3087University Of South Australia

Answer To: BUSS 3087 – Managing Decision Making Supplementary Assessment Part 1 – Complete the Spreadsheet...

Sandeep answered on Jul 24 2021
151 Votes
Documentation
    Instructions for Users
    These instructions assist the user in …
    Step 1:
    Step 2:
    Step 3:
    Step 4:
    Step 5:
    Documentation for Developers
Input
    Average occupancy per day    Rooms occupied                Fitness Equipment    Quantity        Kitchen Equipment    Quantity
    Double    5                Treadmill    4        1220L 2 door commercial fridge    10
    Double Deluxe    1                Airbike    2        1220L 2 door commercial freezer    10
    Full Double    1.25                Cross trainer    2        Commercial 34L electric deep fryer    10
    Queen    3                Medicine ball set (1 each of 3kg, 4kg, 5kg, 7kg and 10kg)    5        AT-360B Toaster/Griller/Salamander    10
    Queen Deluxe    2                Kettle bell set (1 each of 8kg, 12kg and 16kg)    0        CR257 - Turbofan Full size digital electric combi oven    10
    Double Queen    3                Flat bench    2        6BT-OV-900B 6 burner gas range with oven    10
    Suite    4                Fitness mats    2        LUUS BCH-9P 900mm griddle    10
    Antique Suite    2                Fitball    2        C24 Roband curved glass heated bain marie 8pc x GN 1/2 trays    10
                        55cm    2        HYWCL12 Pull down heat lamps antique copper 290mm round    10
        Breakfast    Lunch    Dinner        75cm    2        2L commercial blender    10
    Average restaurant patrons (per week)    2    2    2        85cm    2        Heavy duty 20L planetary mixer    10
    Average $ spend in rest per patron    2    2    2        Handweight set and rack (0.5kg-20kg)    2        Commercial electric meat grinder/mincer    10
    Average food costs (per week)    2    2    2                    BV600-180B SS Bench table with splashback    10
    Type of paint    Modern Paint
    Flooring    Slate
    Mattress quality    Medium
    Extra pillows (per room/bed)    1
    Quality of fridge
    Quality of microwave
Output
    Quotation Comparison                                Budget
                                        Weekly
        AAA    Hotel Quality    Renovations R US                    Projected Income
    General Upgrade    5000    5000    5000                    Guest Rooms    $10,000.00
    Guest Room    5000    5000    5000                    Restaurant    $ 70,000.00
    Kitchen    5000    5000    5000
    Restaurant    5000    5000    5000                    Expenses
    Fitness    5000    5000    5000                    Wages    2000
    Total Costs    25000    25000    25000                    Food Costs    3000
                                    Weekly Profit/Loss    10000
                                        AAA    Hotel Quality    Renovations R US
                                    Renovation Expense    $1,000.00    $20,000.00    $2,000.00
                                    Week until Profitable    $2.00    3    4
    Back to Inputs
Calculations
    General Upgrades
        AAA    Hotel Quality    Renovations R US
    Paint Cost    $12,050.00    $1,900.00    $2,000.00
    Flooring    $72,900.00    $4,000.00    $5,000.00
    Tiles    $14,700.00    $15,000.00    $16,000.00
    Lights    $2,000.00    $3,000.00    $2,500.00
    Carpet Removal    100    $100.00    $100.00
    New Entrance    125    $112.50    $101.25
    Reception Upgrade    300    $270.00    $243.00
    New Booking System    3500    $3,150.00    $2,835.00
    Deep Clean    2000    $1,800.00    $1,620.00
        1200    $1,080.00    $972.00
    Total Cost General Upgrade        $0.00    $0.00
            $0.00    $0.00
    Guest Room Upgrade    0    $0.00    $0.00
    Mattress Costs    0    $0.00    $0.00
    Sheet sets (includes 2 pillow cases)    0    $0.00    $0.00
    Pillow cases (extra)    0    $0.00    $0.00
    Bath towels    50    $50.00    $50.00
    Bath mats    5000    $5,000.00    $5,000.00
    Hand towels     5000    $5,000.00    $5,000.00
    New pillows for each bed     5000    $5,000.00    $5,000.00
    Additional pillows per bed    5000    $5,000.00    $5,000.00
    New fridge (120L) for each room    5000    $5,000.00    $5,000.00
    New microwave for each room (40L 1000W)    5000    $5,000.00    $5,000.00
    Wardrobes (2 doors/3 drawers) per room    5000    $5,000.00    $5,000.00
    New curtains    5000    $5,000.00    $5,000.00
    Total Cost Guest Room Upgrade    $40,000.00    $40,000.00    $40,000.00
                $0.00
    Fitness Centre Upgrade
        AAA    Hotel Quality    Renovations R US
    Treadmill    $ 1,200.00    $ 1,800.00    $ 1,500.00
    Airbike    $ 1,890.00    $ 1,490.00    $ 1,790.00
    Cross trainer    $ 2,099.00    $ 2,399.00    $ 2,499.00
    Medicine ball set (1 each of 3kg, 4kg, 5kg, 7kg and 10kg)    $ 395.00    $ 425.00    $ 405.00
    Kettle bell set (1 each of 8kg, 12kg and 16kg)    $ 240.00    $ 225.00    $ 210.00
    Flat bench    $ 499.00    $ 525.00    $ 399.00
    Fitness mats    $ 22.00    $ 23.50    $ 25.00
    Fitball
    55cm    $ 19.99    $ ...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?