Solution-Prepare a monthly cash budget for the three months

Prepare a monthly cash budget for the three months

Assignment Help Managerial Accounting

Reference no: EM132990397

Question - During the COVID-19 crisis Ben lost his job and decided to put his savings into a new business called Top End Walkabout Tours. Once the internal travel restrictions were lifted, he intended to make the most of the NT tourist boom by providing the local hotels with customised travel experiences in and around the Top End.

He drew up an estimate of his original cash outlay, income and expenses for the three months to the 30th June 2021.

April May June

Capital investment $83,200

Fees charged (on credit) 26,551 $32,035 $41,847

Fees collected 15,007 19,625 29,437

Office equipment 19,913

Administration expenses 3,175 3,175 3,175

Advertising and marketing 7,215 5,772 3,463

Monthly cash drawings 3,463 3,463 3,463

Office rent 4,618 4,618 4,618

Required -

a. Prepare a monthly cash budget for the three months ending 30th June, 2021.

b. Prepare a variance report for April 2021 incorporating the following information:

Fees received $10,920

Office equipment 21,320

Cash drawings 6,760

All other cash items agreed with the original budget.

Reference no: EM132990397

Questions Cloud

Accounting and financial analysis : Department manager and ascertain how they utilize accounting and financial analysis in the decision-making process related to patient care

Show the equity section in sun ltd balance sheet : Show the equity section in Sun Ltd.'s balance sheet after the actions detailed below (both actions are independent of each

Find what is koch adjusted basis in machine two : Machine 2's seller purchased it for $64,550 and machine 2's adjusted basis was $55,450 at the time. What is Koch adjusted basis in machine 2 after the exchange?

Healthcare organization finance : Why are balance sheets important to healthcare organization finance and what area of the balance sheet would you consider the most critical?

Prepare a monthly cash budget for the three months : Prepare a monthly cash budget for the three months ending 30th June, 2021. Prepare a variance report for April 2021

What amount of ashburn net gain for year is treated : Ashburn reported a $105,200 net §1231 gain in year 6. What amount of Ashburn's net §1231 gain for year 6, if any, is treated as ordinary income?

Develop strategic action plan for specific issue : Your organization has requested that you develop a strategic action plan for a specific issue the healthcare organization is facing

Funding a business with an ipo vs issuing bonds : What are the pros and cons of funding a business with an IPO vs. issuing Bonds?

How much overhead was allocated to product b : Question - X Company uses an activity-based costing overhead allocation system. How much overhead was allocated to Product B

User Account

All Pages

Prepare a monthly cash budget for the three months

Reference no: EM132990397

Reference no: EM132990397

Questions Cloud

Reviews

Write a Review

Managerial Accounting Questions & Answers

Manage budgets and financial plans

Prepare a retained earnings statement

Prepare a master budget for the three-month period

Construct the companys direct labor budget

Evaluate the predetermined overhead rate

Determine the company''s bid

Compute the pool rates for the different activities

Prepare Company financial statements

Prepare an analysis of terracycles

Discuss the ethical issues

Political resources in emerging markets

Management accounting - ehsan electronics company

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT