700322 Decision Making for Business: Organise Data Into Excel Workbook

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

Enter e-mail

Phone no

Pages

250 words

Deadline

Order description (write / attach)

I accept the T&C and other policies of the website and agree to receive offers and updates.

Students Who Viewed This Also Studied

131 Pages

BAO3403 investmnent and portfolio management

Part a. You are an investment adviser. One of your clients approaches you for your advice on investing in equity shares of Alpha Company. You have collected the following data: Earnings per share ...

Course

BAO3403

Type

Home Work

Subject

Finance

University

Victoria University

View Document

14 Pages

ECON7200 Economics of Financial Markets

Questions: In part C answer only One question, either C1 or C2. you must type the answer to part C, as they will be checked for plagiarism. c1 and c2 reading at below file the word will 6 ...

Course

ECON7200

Type

Essay

Subject

Finance

University

The University of Queensland

View Document

28 Pages

BFA107 Financial Management

Task: The initial investment is $200,000 for Project A and $300,000 for Project B. Pendlebury’s cost of capital is 10%.The expected cash inflows for each project over the next four ye ...

Course

BFA107

Type

Course Work

Subject

Finance

University

University of Tasmania

View Document

22 Pages

BEA602 Derivative Securities

Questions: Q1 a) Find the 3 month US treasury rate and the closing price of the S&P 500 for the day your option is traded. b) Using the implied volatility value from the “XYZ Co ...

Course

BEA602

Type

Assignment

Subject

Finance

University

University of Tasmania

Season

Fall

View Document

700322 Decision Making for Business

Question

Answered

Questions:

Background

You are the manager of a small business – a café – that has just installed Microsoft Excel on its office computer with the objective of organising its record-keeping functions. All the files have been saved in a common location, but the information is scattered and disorganised. Help the business to organise its data efficiently into one Excel workbook.

Q1 – Supplies Order

The café ordered barista supplies from a supplier and needs to track which order is coming in when, and also the total costs.

Expected Delivery Date	Items Ordered	Cost per Item	Quantity Ordered
05/09/2021	Milk Jugs	$39.00	12
17/09/2021	Barista Coffee Tamper	$49.95	9
01/09/2021	Coffee Thermometer	$10.90	15
19/09/2021	60 ml Espresso Measure Glass	$9.95	17

Required

Create the following table in Excel and populate the columns and rows using the data provided in the question and your own answers where required.

Q1 - Supplies Order
Expected Delivery Date	Items Ordered	Cost per Item	Quantity Ordered	Total Cost per item

Calculate the total cost per item in the 5th column
Ensure that you keep all Excel formulas used in the calculation(s).
Insert a filter in the 2^ndtop row and sort the table from ‘oldest to newest’ expected delivery date.

Round your answers to 2 decimal places using the rounding function in Excel and insert $ signs where appropriate.

Question 2 – Credit Purchases

The café has just purchased several items on credit. This means they will pay for the cost in instalments over the next few years. The manager need to work out an equal monthly payment for each of the items purchased. Assume no interest is paid.

The items purchased are as follows:

Coffee grinder, which costs $ 5,400 and will be paid off in 15 months.
Ice machine, which costs $1,976.75 and will be paid off in 12 months.
Furniture (Tables, chairs, & stools), which cost $9,000 and will be paid off in 18 months.
Three-compartment sink, which costs $990 and will be paid off in 9 months.
Espresso machine which costs $8,999 and will be paid off in 30 months

Required –

Create the following table in Excel and populate the columns and rows using the data provided in the question and your own answers where required

Q2 - Credit Purchases
Item	Cost per item	Payment Period (months)	Monthly payment

Calculate the monthly payment for each item in the last column of your table (2 marks)
Ensure that you keep all Excel formulas used in the calculation(s) (1 mark).
Insert a filter in the 2^ndtop row and sort the table from ‘largest to smallest’ monthly payment

(1 mark).

Round your answers to 2 decimal places using the rounding function in Excel and insert $ signs where appropriate

Question 3 – Telephone Sales

The café has 5 operators casually employed to make telephone sales.

Below is critical information in determining the team’s daily bonus:

Sanya has worked 4 hours and made 35 calls.
Adam made 21 calls in 3 hours.
Nick worked for 2 hour and made 10 calls.
Wahid made 26 calls in 4 hours.
George made 35 calls in 5 hours.

The daily bonus is calculated as 8.75 times the team’s average number of calls per hour.

For example, if the team averaged 10 calls per hour, then the team will receive a bonus of $(10*8.75) = $87.50.

Required –

Create the following table in Excel and populate the columns and rows using the data provided in the question and your own answers where required.

Q3 - Telephone Sales
	Number of calls made	Number of hours worked
Adam
Sanya
George
Nick
Wahid
Team's Total
Team's average calls per hour
Team's daily bonus

Calculate the team’s total number of calls made, and hours worked
Calculate the team’s average calls per hour
Calculate the team’s daily bonus
Ensure that you keep all Excel formulas used in the calculations
Round your answers to 2 decimal places using the rounding function in EXCEL and insert $ signs where appropriate

700322 Decision Making for Business

Answer in Detail

i Solved by qualified expert

Get Access to This Answer

Get Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Page 1 of 34

33 More Pages to Come in This Document. Get access to the complete answer.

More 700322 700322 Decision Making for Business: Questions & Answers

Finance

BAO3403

Victoria University

BAO3403 investmnent and portfolio management

Part a. You are an investment adviser. One of your clients approaches you for your advice on investing in equity shares of Alpha Company. You have collected the following data: Earnings per share last year $4.00 Payout ratio 0.40Return on equity 0.25Cost of equity capital 0.20 The company plan ...

View Answer

Finance

ECON7200

The University of Queensland

ECON7200 Economics of Financial Markets

Questions: In part C answer only One question, either C1 or C2. you must type the answer to part C, as they will be checked for plagiarism. c1 and c2 reading at below file the word will 600-1200, dont need too much word, i book 1000 word just hope u can well down the job C1. (50 marks) ...

View Answer

Finance

BFA107

University of Tasmania

BFA107 Financial Management

Task: The initial investment is $200,000 for Project A and $300,000 for Project B. Pendlebury’s cost of capital is 10%.The expected cash inflows for each project over the next four years are as follows: Project A Project BYear Net cash inflows ...

View Answer

Finance

BEA602

University of Tasmania

BEA602 Derivative Securities

Questions: Q1 a) Find the 3 month US treasury rate and the closing price of the S&P 500 for the day your option is traded. b) Using the implied volatility value from the “XYZ Company”file for your option as the volatility input to the Black-Scholes model (including a div ...

View Answer

Choose Our Best Expert to Help You

Maxwell West

Master of Psychology with Specialization in Neuropsychology

1490 - Completed Orders

Hire Me

Genevieve Dugan

Masters in Statistics

2118 - Completed Orders

Hire Me

Simon Harper

MSc in Chemistry

2160 - Completed Orders

Hire Me

Leigh Schmidt

PhD in Psychology with specialization in Developmental Psychology

207 - Completed Orders

Hire Me

Writing Tools

700322 Decision Making for Business

Stuck on Your Question?

Phone no. Missing!

Files Missing!

Students Who Viewed This Also Studied

BAO3403 investmnent and portfolio management

ECON7200 Economics of Financial Markets

BFA107 Financial Management

BEA602 Derivative Securities

700322 Decision Making for Business

Question

Questions:

Background

Q1 – Supplies Order

Required

Question 2 – Credit Purchases

Required –

Question 3 – Telephone Sales

Required –

700322 Decision Making for Business

Answer in Detail

Get Access to This Answer

33 More Pages to Come in This Document. Get access to the complete answer.

More 700322 700322 Decision Making for Business: Questions & Answers

BAO3403 investmnent and portfolio management

ECON7200 Economics of Financial Markets

BFA107 Financial Management

BEA602 Derivative Securities

Content Removal Request

Choose Our Best Expert to Help You

Maxwell West

Genevieve Dugan

Simon Harper

Leigh Schmidt

5% Cashback

Download app now (or) Scan the QR code

Business Intelligence

Have any Query?

Have any Query?

Contact with us