Schedules of expected cash collections

Assignment Help Financial Accounting
Reference no: EM131292935

Miken Company:

The following data relate to the operations of Miken Comapny, a distributor of consumer goods.

Accounts as of March 31:

         Cash                                $8,000

         A/R                                  $20,000

         Inventory                         $36,000

         Building & Equip (net)        $120,000

         A/P                                  $21,750

         Capital stock                    $150,000

         Retained Earnings             $12,250

A. The gross margin is 25% of sales

B. Actual and budgeted sales data:

            March (actual)         $50,000

            April                       $60,000

            May                        $72,000

            June                       $90,000

            July                        $48,000

C. Sales are 60% cash and 40% credit. Credit sales are collected in the month following sale. The A/R at March 31 are a result of March credit sales.

D. Each month's ending inventory should equal 80% of the following month's budgeted COGS

E. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid for in the following month. The A/P at March 31 are the result of March purchases of inventory

F. Monthly expenses are as follows: commissions, 12% of sales; rent, $2,500 per month; other expenses (excluding depreciation), 6% of sales. Assume that these expenses are paid monthly. Depreciation is $900 per month.

G. Equipment costing $1,500 will be purchased for cash in April

H. The company must maintain a minimum cash balance of $4,000. An open line of credit is available at a local bank. All borrowing is done at the beginning of a month, and all repayments are made at the end of the month; borrowing must be in multiples of $1,000. The annual interest rate is 12%. Interst is paid only at the time of repayment of principal. (figure interest in whole months 1/12, 3/12, etc.)

Using this information complete the following schedules:

1. Schedules of expected cash collections

2. Merchandise purchase budget

3. Schedule of cash disbursments (merchandise)

4. Schedule of cash disbursments (operating expenses)

5. Cash budget

Reference no: EM131292935

Questions Cloud

Seasonal or cyclical patterns : Holt-Winter's double exponential smoothing would be an appropriate method to use to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns.
What challenges did you and your team face : What challenges did you and your team face? What actions did you take to address and resolve the challenges? Describe in detail.In your judgment, was your team's training program effective in meeting the written objectives? Explain.How effective were..
Describe the effect of each payment basis on output : Four common bases of payment for physicians are salary,fee for service,fee per case,and capitation. Describe the effect of each payment basis on output. Discuss studies that have examined the relative costs and benefits of each payment system.
Discuss the role of the delphi technique in product research : Explain how marketing research can be used in product generating and testing.- Discuss the role of the Delphi technique in product research.
Schedules of expected cash collections : The following data relate to the operations of Miken Comapny, a distributor of consumer goods. Using this information complete the following schedules: Schedules of expected cash collections. Merchandise purchase budget. Schedule of cash disbursments..
Department for a tire manufacturing company : The manager of the quality department for a tire manufacturing company wants to know the average tensile strength of rubber used in making a certain brand of radial tire. She knows the population standard deviation and uses a Z test to test the nu..
How firms obtain information about competitors strategy : Discuss the problems involved in identifying competitors and indicate how firms might obtain information about competitors' strategies and intended strategies.
Condorcet paradox and arrow impossibility theorem : What is the Condorcet paradox and arrow's impossibility theorem in the political economy?
Suggest a research proposal that could be implemented : How the concepts of market segmentation, targeting and positioning and the marketing mix might be profitably applied to re-establish Bukhara as a tourist destination rather than merely an overnight stop in the minds of tourists.

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is the minimum cost of crashing the project by 3 days

What is the minimum cost of crashing the following project by 3 days?

  Calculate worthigton gross pay payroll deductions

Calculate Worthigton's gross pay, payroll deductions and net pay for the full year 2012. Round all amounts to the nearest dollar

  Financial and managerial accounting

Explain to her the similarities and differences between financial and managerial accounting.

  Resulted from lower lifo inventory levels

The following inventory note appears in General Electric’s 2011 annual report. General Electric Company Edited Inventory Note 2011 2010 (millions of dollars) Raw materials and work in process $ 4,894 $ 4,708 Finished goods 4,379 3,951 Unbilled shipme..

  Computation of par value of stock after split off

How much of the $1,000,000 notes payable should be classified as current in Reeds balance sheet at December, 2007 and Computation of par value of stock after split off

  Determine the cash payments made during april

During February, $186,500 was paid to creditors on account, and purchases on account were $201,400. Assuming the February 28 balance of Accounts Payable was $59,900, determine the account balance on February 1. On April 1, the cash account balance wa..

  Summary commentary regarding inventory accounting method

Provide a summary commentary regarding the inventory accounting method, the depreciation method(s), and the overall composition of total assets.

  Exemptions and standard deductions

Using the following information for tax year 2013, determine if each of the individuals could quality as: Taxpayer’s son has gross income of $7,000. Taxpayer’s niece has gross income of $3,000. Determine the amount of standard deduction for tax year ..

  Evaluate compensation expense

Organize journal entries relating to the stock-option plan for the years 2012, 2013, and 2014. Consider that the employee performs services equally in 2012 and 2013

  Chart of accounts for exact wording of account titles

Art Imaging Company was organized on April 1 of the current year. On April 2, Art Imaging Company prepaid $54,000 to the city for taxes (license fees) for the next 12 months and debited the prepaid taxes account. Journalize the two adjusting entries ..

  Determine discounted payback period of the proposed project

Determine The discounted payback period of the proposed project and The payback period of the proposed investment (assume that cash inflows occur evenly throughout the year).

  Compute the current ratio as of january 2012

Prepare a statement of cash flows for the year 2012 and compute the current ratio (current assets 4 current liabilities) as of January 1, 2012, and December 31, 2012, and compute free cash flow for the year 2012.

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