Coopie Awards' master budget, accounting homework help

User Generated

zneqvr3

Business Finance

Description

Use the following Excel Template to complete your assignment for this week:

Excel Template

Given financial information, prepare Coopie Awards' master budget. Notice, you will prepare a different budget on each tab of the spreadsheet. The last tab in the spreadsheet you will complete for the discussion forum.


Unformatted Attachment Preview

Your Name Your Travel Destination Contact Name Number of Travelers 3 2 2 1 1 4 Insurance Cost 250 250 250 - Total Cost of Trip: Down Payment 8.000 6.500 6.400 1.000 1.500 12.000 Amount Due Total: Number of travelers times the cost of the trip plus insurance. (remember absolute and relative) Amount Due: Total minus Down Payment Helpful and Important Hints: Remember absolute and relative when calculating the Total. The formula in the total should work without you changing anything if someone calls in and adds insurance. The formula in the total should also work without you changing anything in case the trip cost changes nd relative) adds insurance. st changes 3500
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Your Name
Your Travel Destination
Contact Name

Number of
Travelers
3
2
2
1
1
4

Insurance
Cost
250
250
250

Total
10,750
7,000
7,250
3,500
3,750
14,000

Cost of Trip:
Down
Payment
8,000
6,500
6,400
1,000
1,500
12,000

Amount
Due
2,750
500
850
2,500
2,250
2,000

Total: Number of travelers times the cost of the trip plus insurance. (remember absolute and relative)
Amount Due: Total minus Down Payment
Helpful and Important Hints:
Remember absolute and relative when calculating the Total.
The formula in the total should work without you changing anything if someone calls in and adds insurance.
The formula in the total should also work without you changing anything in case the trip cost changes

nd relative)

adds insurance.
st changes

3500

There is unfavourable revenue because the actual results is less than the actual based budget. This makes it very difficult to a

et. This makes it very difficult to attain when the problem is to be corrected. There is a less income for the ammount that was budgetted.

he ammount that was budgetted. The pther factors are favourable to the company which is good for its perfomance. the copmany need t

perfomance. the copmany need to reduce the sales budget or aim higher for it.


Coopie Awards produces brass plaques. They operates in 3 regions of the country. The western regio...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags