Prepare a cash budget for the first two quarters

Assignment Help Managerial Accounting
Reference no: EM133014280

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

18,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 cashflow position in the first two quarters of the year.

Reference no: EM133014280

Questions Cloud

Prepare the consolidation journal entries that Large Ltd : During the 2019/2020 financial year, Small Ltd sold inventory to Large Ltd at a sales price of $200,000. Prepare consolidation journal entries that Large Ltd
How much is the individual capital of alpha and charlie : The excess is considered as a revaluation (goodwill) to be recognized. How much is the individual capital of Alpha and Charlie after the withdrawal of Beta
Calculate the forward rate with quarterly compounding : The six-month rate is 14% per annum and the nine-month rate is 15% per annum with continuous compounding. Calculate the forward rate with quarterly compounding
Calculate its ending cash balance : Wobble Inc. has a beginning cash balance of $5,980. Its liquidity metric for the period has increased by $1,972. Calculate its ending cash balance
Prepare a cash budget for the first two quarters : Additional data: Equipment was sold in July for $8,000 and $4,500 in November. Prepare a cash budget for the first two quarters
What is the carrying amount of the investment : The carrying amount of the acquired shares was P6,000,000. What is the carrying amount of the investment in Pangasinan Company on December 31, 2021
Developing an ecommerce presence : What are the main factors to consider when developing an eCommerce presence? Which factor do you consider to be the most important? Why?
What is the price of the bond : Question - A bond has a maturity of 2 years and pays a coupon of 4%. The YTM is 2.25%. What is the price of the bond
Set up a schedule of interest expense : Sunland Company sells 10% bonds having a maturity value of $2,120,000 for $1,967,165. Set up a schedule of interest expense

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Find what are the relevant facts of the situation

Find What are the relevant facts of the situation? What are the ethical issues? What are the alternatives? What would you do and why?

  Explain what information would request from accounting

Each region has a sales representative, What information would you request from the accounting department to help confirm or negate these accusations?

  Make an expected cash collection budget for the month

The LePann Company has started,Make an expected cash collection budget for the month of July, August, September and for the quarter

  Should the company accept this special order

The company has just received a special one-time order for 400 medals at $74 each. Should the company accept this special order

  Find the firm ROA and asset turnover ratio

Torrid Romance Publishers has a total receivable of $3,020, which represents 20 days' sales. Find the firm ROA and asset turnover ratio

  Should buy the new digital printing system

Based on the following, should we buy this new digital printing system? Use the table below to plan your cash flows. Bold boxes are where should go

  Prepare a work sheet for printer repair company

The Trial Balance of the Printer Repair Company, prepare a work sheet for Printer Repair Company. Arrange the accounts in their approximate usual order.

  Compute the project profitability index for each investment

Compute the project profitability index for each investment proposal. Preference Ranking,Information on four investment proposals

  Find fixed costs traceable to department

On the basis of this information, fixed costs traceable to Department no. 2 but controllable by others are. The data relate to Department no. 2

  Determine the profit-maximising production mix for the month

Determine the profit-maximising production mix for this month, assuming that monthly fixed costs are $4,000, and that opening inventories

  Which the activities involved during the negotiation stage

Which the activities involved during the negotiation stage of a consulting engagement include the following except? Identification of the end product of asset

  How do determine the unit break-even point

Determine the unit break-even point, assuming fixed costs are $60,000 per period, variable costs are $16.00 per unit, and the sales price is $25.00 per unit?

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