What is spicer budgeted cash balance at the ends of march

Assignment Help Managerial Accounting
Reference no: EM132970002

On March 1 of the current year, Spicer Corporation compiled information to prepare cash budget for March, April, and May. All of the company's sales are made on account.

The following information has been provided by Spicer's management.

Month   Credit Sales

January $300,000 (actual)
February $400,000 (actual)
March $509,000 (estimated)
April $558,000 (estimated)
May $800,000 (estimated)

The company's collection activity on credit sales historically has been as follows.

Collections in the month of the sale 50%
Collections one month after the sale 30%
Collections two months after the sale 15%
Uncollectible accounts 5%

Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400,000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter.

Problem 1:
What is Spicer's budgeted cash balance at the ends of March, April, and May?

Reference no: EM132970002

Questions Cloud

Why depreciation added to income in statement of cash flows : Where is depreciation reported in the company's statement of cash flows? Why is depreciation added to income in the statement of cash flows?
Compute the total budget variances for materials : Compute the total budget variances for materials and labor assuming that actual number of electronic kits purchased and used were 7,300 at a price
Prepare a partial income statement for september showing : Prepare a partial income statement for September showing gross margin for both products separately. Assume that both products are sold at the splitoff point
Which is the coordinate for the new plant location : Which is the coordinate for the new plant location? Plant A is located at the (X, Y)(X, Y)X coordinates of (100, 200) and has a volume of shipping.
What is spicer budgeted cash balance at the ends of march : What is Spicer's budgeted cash balance at the ends of March, April, and May? Spicer's total cash expenditures for March, April, and May have been estimated
Find what will payment be : The loan requires quarterly payments, each made at the end of the quarter. The loan period is 5 years, and the interest rate is 8%. What will your payment be?
Which of statements are true about managerial perspective : Which of statements are true about the managerial perspective? Glenn, a manager at Olive Corp., has decided to adopt a managerial perspective
Why does the central bank of canada have a target : Why does the Central Bank of Canada have a target for the rate of inflation? In particular, why is it important for the Central Bank to make inflation rates
Why the issuance of sukuk bonds to finance : Question: Why the issuance of Sukuk bonds to finance the next set of planes is more beneficial than conventional financing arrangement?

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