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

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Will the breakeven unit be increased or decreased

If Home Depot decides to allocate more resources on marketing/advertising, will the breakeven unit be increased or decreased? Provide the suitable example.

  Compute the net present value for this machine

Compute the net present value for this machine using a discount rate of 8% and assuming that cash flows occur at each year-end

  Materials quantity variance for march

The company applies variable overhead on the basis of direct labor-hours. The direct materials price variance is computed when the materials are purchased.

  Calculate the net benefit or cost to turun telelaitos

Calculate the net benefit or cost to Turun Telelaitos from implementing a JIT production system. What other non-financial and qualitative factors should Turun Telelaitos consider before deciding on whether it should implement a JIT system?

  What groups managerial accountants interact with closely

They need to interact and provide guidance to a broad range of internal customers. What are some other groups managerial accountants interact with closely?

  How the use of activity based management

How the use of Activity Based Management (ABM) and Business Process Re-engineering (BPR) could help to improve competitiveness

  Prepare a differential analysis dated july

Prepare a differential analysis dated July 7 to determine whether the company should make or buy the bread, assuming that fixed costs are unaffected

  Outline underlying assumptions and three uses for cvp

Outline the underlying assumptions and at least three uses for CVP (Cost Volume Profit) analysis. How are CVP analysis and breakeven analysis related?

  Do agree with the given statement why or why not

People are generally concerned with the performance of all sub-units within the organization. Do you agree with the given statement? Why or why not?

  How many units of production were assumed

For the Win (FTW) Corporation, How many units of production were assumed when the predetermined application rate for fixed overhead was established?

  How important should changes in roe be in the decision

Envision Inc is considering the acquisition,How important should changes in ROE be in this decision? Is the managerial correct in predicting that ROE will fall?

  What must perform a cost volume profit analysis

What are some examples in our own personal life that we must perform a cost volume profit analysis? Any examples and how one would use it in everyday life

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd