Purchase Solution

5 Managerial Accounting Problems

Not what you're looking for?

Ask Custom Question

See attached file for clarity.

1. The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March)

Estimated sales for January $ 100,000
Sales increase by 5% for the coming three months
Cost of goods sold (CGS) 60% of sales
Beginning inventory $ 12,000
Ending inventory equal to 20% 0f next month CGS
Find the total purchases needed for February.

1. between $60,000 and $61,000

2. between $63,000 and $64,000

3. between $66,000 and $67,000

4. between $68,000 and $69,000

2. The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March)

Estimated sales for January $ 100,000
Sales increase by 5% for the coming three months
Cost of goods sold (CGS) 60% of sales
Beginning inventory $ 12,000
Ending inventory equal to 20% 0f next month CGS
Find the total purchases needed for March.

1. between $60,000 and $61,000

2. between $63,000 and $64,000

3. between $66,000 and $67,000

4. between $68,000 and $69,000

3. The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March)

Estimated sales for January $ 100,000
Sales increase by 5% for the coming three months
Cost of goods sold (CGS) 60% of sales
Beginning inventory $ 12,000
Ending inventory equal to 20% 0f next month CGS
Find the total purchases needed for January.

1. between $60,000 and $61,000

2. between $63,000 and $64,000

3. between $66,000 and $67,000

4. between $68,000 and $69,000

4. Assume the following data pertains to ABC Company
Estimated average selling price per unit $10.00
Estimated units to be sold in 8-2009 1,000.00
Estimated increase in unit sales 10%
Month 8 9 10 11
Units 1,000 1,100 1,210 1,331
Selling price per unit $ 10.00 $ 10.00 $ 10.00 $ 10.00
Total estimated sales $ 10,000.00 $ 11,000.00 $12,100.00 $13,310.00
Assume
Cost of goods sold (CGS) 65% of sales
Month 8 9 10
Estimated CGS $ 6,500.00 $ 7,150.00 $ 7,865.00 $ 8,651.50
Assume
Beginning inventory $ 2,100.00
Ending inventory 20% next month CGS
Find the purchases needed for September

1. Between $5,200 and $5,300

2. Between $7,200 and $7,300

3. Between $5,800 and $5,900

4. Between $8,00 and $8,100

5. Assume the following data pertains to ABC Company
Estimated average selling price per unit $10.00
Estimated units to be sold in 8-2009 1,000.00
Estimated increase in unit sales 10%
Month 8 9 10 11
Units 1,000 1,100 1,210 1,331
Selling price per unit $ 10.00 $ 10.00 $ 10.00 $ 10.00
Total estimated sales $ 10,000.00 $ 11,000.00 $12,100.00 $13,310.00
Assume
Cost of goods sold (CGS) 65% of sales
Month 8 9 10
Estimated CGS $ 6,500.00 $ 7,150.00 $ 7,865.00 $ 8,651.50
Assume
Beginning inventory $ 2,100.00
Ending inventory 20% next month CGS
Find the purchases needed for August

1. Between $5,200 and $5,300

2. Between $7,200 and $7,300

3. Between $5,800 and $5,900

4. Between $8,00 and $8,100

Attachments
Purchase this Solution

Solution Summary

This solution provides a complete computation of the given accounting problems in Excel format.

Solution Preview

** Please see the attached files for the complete solution response **

Answer
jan feb march april
sales 100000 105000 105000 105000
cost of goods sold 60000 63000 63000 63000
opening inventory 12000 12600 12600
ending ...

Purchase this Solution


Free BrainMass Quizzes
IPOs

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

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking