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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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