Solution-Prepare the schedule of expected cash collections

Prepare the schedule of expected cash collections

Assignment Help Managerial Accounting

Reference no: EM133120812

Question 1 - Explain how a flexible budget can be of value to businesses.

Question 2 - Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows:

Month	Sales ($)	Units Sold
May	25,000	250
June	28,000	280
July	30,000	300
August	40,000	400
September	35,000	350
October	37,000	370

Additional information:

i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase.

ii) Closing inventory must equal 50% of the next month's sales.

iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale.

iv) The balance in the bank account as of 30 June is $10,000.

Required -

1. Prepare a purchases budget (in units and $) for the 1st quarter. (Purchases are based on expected sales).

2. Prepare the schedule of expected cash collections from Accounts Receivable for the months of July and August.

Reference no: EM133120812

Questions Cloud

Relationship between annual objectives and policies : Briefly explain the seven guidelines to follow in developing an organizational chart. Describe the relationship between annual objectives and policies.

Find out the price of the underlying stock : You are given the following prices for 1-year European call options:

What is the required rate of return on a stock : A's stock pays a dividend once each year, and it just paid a dividend of $0.85 yesterday. The current market price of the stock is $12.14.

Design a swap that will net a bank : Companies X and Y have been offered the following rates per annum on a $5 million 3-years investment:

Prepare the schedule of expected cash collections : Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. Prepare the schedule of expected cash collections

Find out the total equity value and share price : For the year ending Dec. 31, 2021, MLH Corp. had EBITDA = $8 million, and Net Income = $4 million. At the time, MLH had debt of $8 million, excess cash of $6 mi

What other investment options does john have : 1. John receives $1,000 as a graduation gift from his grandparents. Rather than spend it, he decides to invest it in a two-year bonds than earns 3% simple inter

STA8170 Statistics for Quantitative Researchers Assignment : STA8170 Statistics for Quantitative Researchers Assignment Help and Solution, University of Southern Queensland - Assessment Writing Service

What is the minimum estimated value : If the merger makes economic sense for David, what is the minimum estimated value of the synergistic benefits from the merger

User Account

All Pages

Prepare the schedule of expected cash collections

Reference no: EM133120812

Reference no: EM133120812

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