Purchase Solution

Store Operations for Mikell Supplies

Not what you're looking for?

Ask Custom Question

6. Mikell supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:

Sales are budgeted at $360,000 for November, $380,000 for December, and $350,000 for January. Collections are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is 65% of sales. The company maintains a targeted ending inventory of 60% of the following month's sales. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $21,900. Monthly depreciation is $20,000.

Required:

a. Prepare a Schedule of Expected Cash Collections for November and December.
b. Prepare a Merchandise Purchases Budget for November and December.
c. Prepare Cash Budgets for November and December.
d. Prepare a Budgeted Income Statement for the two month period of November and December.
e. Prepare a Budgeted Balance Sheet for the end of December.

Attachments
Purchase this Solution
Solution Summary

The solution examines Mikell Supplies store operations.

Purchase this Solution
Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

View More Free Quizzes
Related BrainMass Solutions

  • Manufacturing Systems

    The defects that passed on by the previous operations is carried by the next process. There is limited scope for rectifying the defects.

  • Departmental income statements

    No changes for those departments' gross profit percents or for their direct expenses are expected, except for store supplies used, which will increase in proportion to sales.

  • McDonalds Warehouse services

    employees for supply chain, focus on operations and training of operations employees

  • Petsmart's Management Team

    Collectively they bring multiple skills from different domains such as retail, finance, strategy, human resources, information systems, marketing, store operations, supply chain. For example Mr.

  • Budget variance including flexible budget

    The workers used 225 storage bins on average each day to sort, store, and process goods for shipment.

  • Strategic supply chain management

    Second, the operations division supplies the quality they make; the marketing division demands the quality that they have promised to the grocery chain.

  • Retail Plan

    The variety store will have cooking supplies, small tools, personal hygiene supplies, electronics supplies, gardening supplies, pet supplies, out of print books, food products, automotive supplies and DVDs.

  • BE4-4 & BE4-9: closing and correcting entries

    The purchase of store supplies on account for $1,580 was recorded as a debit to Store Supplies $1,850 and a credit to Accounts Payable $1,850. Please see the attached file.

  • Plantworld: develop a regression model to explain and predict supplies expense

    He has collected these data for store hours, sales dollars, sales employee hours worked and supplies expenses for Jul 2003 through Jan 2006, and has estimated employee hours, sales dollars, store hours for the next 12 months.

View More Related Solutions