Cash disbursements for operating expenses

Assignment Help Financial Accounting
Reference no: EM13825489

Rocky Shoes sells snow climbing shoes worldwide. They expect to sell 8,500 pairs for $180 each in January 2016; 3,500 pairs for $190 each in February 2016; 4,100 pairs for $260 each in March 2016; and, 3,500 pairs for $250 each in April 2016. Sales in November 2015 and December 2015 were $400,000 and $425,000, respectively. Rocky’s shoes cost of goods sold average 60% of Sales Revenue. Their target ending inventory is $10,000 plus 50% of next month’s cost of goods sold. All sales are on account. Accounts are collected 50% in the month of sale; 30% in the month after the sale; 18% two months after the sale; and, 2% are never collected. Rocky's shoes pays for their purchases 50% in the month of purchase and 50% in the month after purchase.

Rocky's has operating expenses of $30,000 per month of salaries, 1% sales commission, $15,000 rent per month and $5,000 depreciation of equipment per month. All operating expenses except salaries and commissions are paid in the month of incurrence. All commissions and 50% of salaries are paid in the month following incurrence. The company requires a minimum balance of $100,000. Clutcher has a line of equity with their bank to borrow needed funds in increments of $1,000 at an interest rate of 10%. They pay back any borrowings from excess cash as it becomes available. The Cash balance as of December 2015 is $9,500. In February, they plan to purchase a new piece of equipment that will help with the increased production they are expecting beginning in March 2016. The equipment and its installation are expected to cost $457,300. The equipment will be placed in service April 1, 2016. In March they plan to declare and pay a dividend of $150,000 and purchase a parcel of land for their expansion plans costing $2 million for which they will make a down payment of $250,000 and sign a long-term, 8%, 10 year note for the balance.

Required:

Complete the following for the first quarter of 2016, showing each month and a quarter total (Round all calculations to the nearest dollar) (Ignore Income Taxes):

1. Sales Budget

2. Inventory, Cost of Goods Sold, Purchases Budget

3. Operating Expense Budget

4. Cash Receipts Budget, including Net A/R balance for March and Uncollectible expense for the quarter

5. Cash Disbursements for Inventory, including A/P balance for March

6. Cash Disbursements for Operating Expenses

7. Cash Budget, including any necessary borrowing and repayments

8. Budgeted Income statement for March 2016

Reference no: EM13825489

Questions Cloud

Last payday in an accounting period : If $3,000 has been earned by a company’s workers since the last payday in an accounting period, the necessary adjusting entry would be:
The correct journal entry to record the declaration : A cash dividend of $500 was declared and paid to stockholders. The correct journal entry to record the declaration is:
Variable and fixed manufacturing overhead : Blossom, Inc., is a small company that manufactures three versions of patio tables. Unit information for its products follows: Fixed manufacturing overhead. Suppose that direct labor hours has been identified as the bottleneck resource. Determine how..
Mafta malaysia-australia free trade agreement : The Malaysian and Australian leaders have recently agreed to establish a possible FTA between the two nations. The joint experts group estimated that this new free trade area between the two nations would bring some real economic benefits.
Cash disbursements for operating expenses : Rocky Shoes sells snow climbing shoes worldwide. They expect to sell 8,500 pairs for $180 each in January 2016; 3,500 pairs for $190 each in February 2016; 4,100 pairs for $260 each in March 2016; and, 3,500 pairs for $250 each in April 2016. Cash Re..
Using the straight-line method-salvage value : A truck costing $45,000 and having an estimated salvage value of $4,500 and an original life of five years is exchanged for a new truck. The cash price of the new truck is $57,000, and a trade-in allowance of $22,500 is received. The old truck has be..
What is wave motion : What is wave motion and write its interpretation.
The amount of the cash paid : A company purchased $2,000 of merchandise on December 5. On December 7, it returned $100 worth of merchandise. On December 8, it paid the balance in full, taking a 1% discount. The amount of the cash paid on December 8 is:
Explain the different elements of operations management : Explain the different elements of Operations Management

Reviews

Write a Review

Financial Accounting Questions & Answers

  Calculate basic earnings per share for the year

Calculate basic earnings per share for the year ended and calculate diluted earnings per share for the year

  Explain would process costing system met manufacturing

The controller, however, has stated that job costing requires too much recordkeeping. Would a process costing system met the manufacturing vice president's control objectives? Explain

  How many units should jake produce during first quarter

Jakes policy is to maintain an ending inventory equal to 20% of the next quarter sales. each surfboard costs $140 and sol for $200. How many units should jake produce during the first quarter of 2007?

  Purpose a master budgeted income statement

Purpose a Master Budgeted Income Statement using Variable costing and Budgeted Income Statement  ( static ) and Flexible Budgeted Income Statement Variable Costing , Variance Analysis

  What is the cost of waste due to excess inventory

Kate Connor, a teacher at Meadow Middle School, is in charge of ordering the T-shirts to be sold for the school’s annual fund-raising project. The T-shirts are printed with a special Meadow School logo. If the school receives actual sales orders for ..

  Prepare a classified balance sheet and liquidity of company

Prepare a classified balance sheet; assume that $22,000 of the note payable will be paid in 2013 - comment on the liquidity of the company.

  Financial and tax annual accounting period

Salem Corporation uses the calendar year as its financial and tax annual accounting period. Management, because of the seasonality of sales, wants to change to a fiscal year beginning April 1st through March 31st. You have been asked to review the ta..

  Questiondement publishing divisionthe dement publishing

questiondement publishing divisionthe dement publishing division sells large volumes of novels to a few book

  What are the concepts of income and capital

What are the concepts of income and capital? Meaning of utility and limitations of accounting conventions and its problems of valuation and income determination?

  Activity in your organization where you can apply breakeven

activity in your organization where you can apply breakeven analysis.the organizations i chose is best buyidentify any

  Compute the product margins for the xtreme

Compute the product margins for the Xtreme and the Pathfinder products under the activity-based costing system and prepare a quantitative comparison of the traditional and activity-based cost assignments

  Disadvantage of decentralization

Which of the following is a disadvantage of decentralization?

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