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

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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