Reference no: EM131914555
Problem - 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 past experience, 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 actions 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.
Do you think business courses should have a stronger flavor
: Clearly, the business community's influence in America's economic and political life is enormous, but the critics' concerns do not end there.
|
An explanation of why they chose to be whistle blowers
: An explanation of the positive and negative consequences for each possible course of action the guards could have taken.
|
Calculate the annual capital cost allowance
: Calculate the annual capital cost allowance (CCA) and end-of-the-year book value (UCC) for this equipment for the first seven years.
|
Compute the ending inventory for midori company
: Compute the ending inventory for Midori Company for 2013 through 2015 using the dollar-value LIFO method.
|
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
|
What are the total finance charges on loan
: He is making a $2,000 down payment and will be making 60 monthly payments of $541 each. What are the total finance charges on this loan?
|
Develop foundational skills in composing a structured essay
: Analyse the components of the Australian legal systems, and elaborate how these components intersect and interact and how lawyers use these systems.
|
What is miguels basis in the partnership interest
: The land is subject to a $15,000 liability which Miguel assumes. What is Miguel's basis in the partnership interest following the distribution of land?
|
Cumulative preferred shares
: 20,000 common shares1,000, 6%, $100 par cumulative nonconvertible preferred shares2,000, 4%, $50 par cumulative preferred shares
|