Prepare cash budget for the months of july through september

Assignment Help Accounting Basics
Reference no: EM13833395

Cash Budgeting

Retail outlets purchase snowboards from Slopes, Inc., throughout the year. However, in anticipation of late summer and early fall purchases, outlets ramp up inventories from May through August. Outlets are billed when boards are ordered. Invoices are payable within 60 days. From pastexperience, Slopes' accountant projects 20% of invoices will be paid in the month invoices, 50% will be paid in the following month, and 30% of the invoices will be paid two months after the month of invoice. The average selling price per snowboard is $450.

To meet demand, Slopes increases production from April through July, because the snowboards are produced a month prior to their projected sale. Direct materials are purchased in the month of production and are paid for during the following month (terms are payment in full within 30 days of the invoice date). During this period there is no production for inventory, and no materials are purchased for inventory.
Direct manufacturing labor and manufacturing overhead are paid monthly. Variable manufacturing overhead is incurred at the rate of $7 per direct manufacturing labor-hour. Variable marketing costs are driven by the number of sales visits. However, ther are no sales visits during the months studied. Slopes Inc., also incurs fixed manufacturing overhead costs of $5500 per month and fixed nonmanufacturing overhead costs of $2500 per month.

Projected Sales

  • May 80 units
  • June 120 units
  • July 200 units
  • August 100 units
  • September 60 units
  • October 40 units

Direct materials and direct manufacturing labor utilization and cost

  • wood =5 units per board, $30 per unit, unit= board feet
  • fiberglass = 6 units per board, $5 per unit, unit = yard
  • Direct manufacturing labor = 5 units per board, $25 per unit, unit = hour

The beginning cash balance for July 1, 2012 is $10000. On October 1, 2011, Slopes had a cash crunch and borrowed $30000 on a 6% one year note with interest payable monthly. The note is due October 1, 2012. 

Using the information provided, you will need to determine whether Slopes will be in a position to pay off this short term debt on October 1, 2012.

1. Prepare a cash budget for the months of July through September 2012. Show supporting schedules for the calculation of receivables and payables.
2. WIll Slopes be in a position to pay off the $30000 one year note that is due on October 1, 2012. If not, what actionsw would you recommend to Slopes management?
3. Suppose Slopes is interested in maintaining a minimum cash balance of $10000. Will the company be able to maintain such a balance during all three months analyzed? If not, suggest a suitable cash management strategy.

Reference no: EM13833395

Questions Cloud

Price elasticity assumed by consultant-elasticity estimate : The Prestige Office Equipment Company produces and sells different types of office furniture. One of the important items it sells is a high quality desk. Assume the variable unit cost per desk in the coming year will remain the same. Evaluate the pro..
Creating a topic summary- technology and cars : You will be creating a topic summary and APA citation page. But here, in this discussion, you will only choose a topic and do a bit of research on the Internet
Supply and demand schedules-what is the equilibrium price : Below are supply and demand schedules for calzones at a local pizzeria. What is the equilibrium price?  At what price is there a shortage of 60 calzones? At what price is there a surplus of 60 calzones? At a price of $13, there is a surplus of how ma..
Develop a medium to long-term strategy for australia post : Assume that top management would like you to develop a medium to long-term strategy for your organisation or alternatively for one of the following organisations.
Prepare cash budget for the months of july through september : Prepare a cash budget for the months of July through September 2012. Show supporting schedules for the calculation of receivables and payables. WIll Slopes be in a position to pay off the $30000 one year note that is due on October 1, 2012. If not, w..
Final control lab : The SCR in Figure 1 below requires a 3 V trigger.  Using Multsim, design a system by which the gears are shifted when a CdS photocell resistance drops below 4k.
Calculate marginal revenue curves-develop demand schedules : A firm in an oligopolistic industry has identified two sets of demand curves. If the firm is the only one that changes prices (ie., other firms do not follow), its demand curve takes the form Q=82-8P. Calculate marginal revenue curves for each. Devel..
Promote lifelong harmonious social interaction : promote lifelong harmonious social interaction
What is the average fraction of gdp this amount consisted : Collect data on the monetary base in the U.S. What was the size of the monetary base in August of 2007? What about in August of 2009? If the inflation tax is the ?M and the monetary base is our measure of M, then how much revenue was raised from the ..

Reviews

Write a Review

Accounting Basics Questions & Answers

  Leeds architectural consultants began operations on

leeds architectural consultants began operations on january 2. the following activity was recorded in the companys work

  Manufacturing overhead was applied to jobs worked on using

davis inc. uses a job order cost accounting system and keeps perpetual inventory records. the following transactions

  Construction forms corporation buys securities to be

construction forms corporation buys securities to be available for sale when circumstances warrant not to profit from

  Prepare the bank reconciliation statement

Prepare the bank reconciliation statement from the following information. Bank overdraft as per Bank Statement Rs. 4500.

  On january 1 2014 pennington corporation purchased 25 of

on january 1 2014 pennington corporation purchased 25 of the common shares of edwards company for 427000. during the

  On july 1 2013 dipco bonds issued 750 10-year 1000 par

on july 1 2013 dipco bonds issued 750 10-year 1000 par value bonds paying 6 meanwhile other bonds in the market of

  What is the net cash flows from each of the three

what is the net cash flows from each of the three activities operating investing and financing for the most recent

  Property tax purposes

Hurd Company acquired a building valued at $160,000 for property tax purposes in exchange for 10,000 shares of its $5 par common stock. The stock is widely traded and selling for $15 per share.

  Erp implementation case

ERP Implementation Case

  Computing the incremental net income

Starr Company has already manufactured 50,000 units of Product A at a cost of $50 per unit. The 50,000 units can be sold at this stage for $1,250,000. Calculate the Incremental Net Income if processed further.

  Fermentation the grape juice by variety is fermented in

peter catalanos verde vineyards in oakville california produces three varieties of wine merlot viognier and pinot noir.

  Net operating income evaluation

The marketing manager has recommended that the selling price be increased by 25%, with an expected decrease of only 8% in unit sales. What would be the company's net operating income if the marketing manager's recommendation is adopted?

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