Prepare a cash budget for the first two quarters of the year

Assignment Help Managerial Accounting
Reference no: EM133000554

Question - Relevant data from Picta Company's operating budgets are presented below. The company's financial year ends on 30 June.

 

Quarter 1

Quarter 2

Sales

$248,470

$251,539

Direct material purchases

120,295

128,832

Direct labor

76,553

74,289

Manufacturing overhead

26,000

24,400

Selling and administration expenses

33,500

33,500

Depreciation included in selling and administration expenses

2,000

2,500

Collection from customers

230,524

220,116

Cash payments for purchases

114,345

118,346

Additional data: Equipment was sold in July for $8,000 and $4,500 in November. Dividends of $5,500 were paid in August. The beginning cash balance was $80,395 and a required minimum cash balance per quarter is $60,000. The company has a 15% open line of credit for $70 000 with their bank.

Required -

a) Use this information to prepare a cash budget for the first two quarters of the year.

b) Briefly comment on Picta Company's expected cash flow position in the first two quarters of the year.

Reference no: EM133000554

Questions Cloud

What is the amount of revenue cure all ltd can recognise : What is the amount of revenue Cure All Ltd can recognise in the first month of the second year of the contract? The contracts totalled $1,000,000 of revenue.
Make the income statement for the period ended : Make the income statement for the period ended 30th April 2017 and statement of financial position as at the same date
Explain the concept of finance : 1. Explain the concept of finance. 2. How is finance related to other functional areas in a business organization (marketing, production, accounting, etc.)?
What is total amount of revenue cure all ltd can recognise : The contracts totalled $1,000,000 of revenue,What is the total amount of revenue Cure All Ltd can recognise at the end of the first SIX months of the contract?
Prepare a cash budget for the first two quarters of the year : Additional data: Equipment was sold in July for $8,000 and $4,500 in November. Prepare a cash budget for the first two quarters of the year
Housing market stakeholders : If housing prices increase, which housing market stakeholders would tend to have higher income? If borrower's default, which housing market stakeholders faces t
Discuss the three principles of business ethics : a) Under which form(s) of market efficiency can technical analysis be systematically profitable? Briefly explain your answer.
Assignment on options trading : A stock price at time = 0 is 120. At time 1, the stock price will be either 144 or 100. The one-period risk-free effective annual rate of interest is 10%.
What are the elements of an effective project vision : What are the differences between the five-stage model of team development and the punctuated equilibrium model and What are the elements of an effective project

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Write the variable cost income statement

Write the variable cost income statement & absorption cost income statement for the below situation. Variable manufacturing costs: $30.00/unit

  Assess the risks to the business in karen current thinking

Based on your learning on pricing and price discrimination, develop alternate pricing strategies for the firm? Assess the risks to the business in Karen current

  List and define the five categories of activities

In an activity-based costing system, activities are classified into five categories. List and define categories and give one example of each type of activity.

  Determine the customer margin of big sky outfitters

Using the company's activity-based costing system, compute the customer margin of Big Sky Outfitters. (Round your intermediate calculations)

  Give some management accounting tools used in planning

Give some management accounting tools used in planning and controlling the performance of modern businesses considering the following issues

  Should company purchase the blueprint machine and explain

Find the net present value of investment. Ignoring the time value of money, calculate the net cash inflow or outflow resulting from this investment opportunity.

  Find which of the items is relevant to buff decision

Buff Corp. is considering replacing an old machine with a new machine. Which of the following items is NOT relevant to Buff's decision?

  Which of the earnings per common share was closest to

Dividends last year of $1.10 per common share and $0.60 per preferred share. The earnings per common share was closest to which of the following?

  Make a record or journalize all transactions

On Jan 1, 2017 PT Bro had 50,000 shares, $5 par value per share, During the year, the following transactions ocurred. Make Record or journalize all transaction.

  How a budget is useful in the planning process

How A budget is useful in the planning process because it? forces managers to think about goals and objectives and means of achieving them.

  Prepare journal entries to record

Blanche's Boxes makes cardboard shipping cartons in a single operation.

  Explain who else should be concerned with a company

When considering companies' financial statements, Explain who else should be concerned with a company's financial statements and why they are important.

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