Prepare cash budget for the months of july through september

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 ..

User Account

All Pages