Question

In: Accounting

Grippers expects cost of goods sold to average 65% of the current month’s sales and the...

Grippers expects cost of goods sold to average 65% of the current month’s sales and the company expects to sell 4,300 pairs of shoes in March for $240 each.  Grippers’ target ending inventory is $10,000 plus 50% of the next month’s cost of goods sold.

Use this information plus the sales budget from Question 1 to prepare Grippers’ inventory, purchases, and cost of goods sold budget for January and February.

Sales budget from question 1:

Particulars:

Cash Sales in January = 185,000.00

Cash sales in February = 192,500.00

Total = 377,500.00

Credit sales in January = 5,55,000.00

Credit sales in February = 5,77,500.00

Total credit sales = 11,32,500.00

Total Sales in January = 7,40,000.00

Total sales in February = 7,70,000.00

Total = 15,10,000.00

In addition, indicate what the total cost of goods sold will be for the 2 months.

1. cost of goods sold for January is:

2. Cost of goods sold for February is:

3. Total cost of goods sold for the 2 month is:

4. Desired ending inventory for January is:

5. Desired ending inventory for february is:

6. Beginning inventory for January is:

7. Beginning Inventory for February is:

8. Purchases for January are:

9. Purchases for february are:

Solutions

Expert Solution

Please hit like if this helps, comment in case of any further doubts.

1. cost of goods sold for January is:481000

2. Cost of goods sold for February is:500500

3. Total cost of goods sold for the 2 month is:981500

4. Desired ending inventory for January is:260250

5. Desired ending inventory for february is:345400

6. Beginning inventory for January is:250500

7. Beginning Inventory for February is:260250

8. Purchases for January are:490750

9. Purchases for february are:585650


Related Solutions

Current Expenses Average monthly sales over the last quarter was $20,000 Cost of goods sold is...
Current Expenses Average monthly sales over the last quarter was $20,000 Cost of goods sold is $10,000 Promotional costs are $1000 “Other” fixed costs are $1000 Taxes are 30% of your operating profit This leaves you with $5,600 a month, of which, you need $5000 to live on Expansion Costs You have found a commercial office and storage space for $1500 a month. You estimate it would cost you about $1500 a month to hire someone to work 20 hours...
Alamo company has sales, cost of goods sold, and average ending inventory for the current year...
Alamo company has sales, cost of goods sold, and average ending inventory for the current year in the following amounts: $650,000, $500,000,and $128,000,respectively. calculate the amount of the company's inventory turnover for the year. what is the company's average number of days to sell inventory
(1).  ABC expects sales of $21,830,000 this year. The cost of goods sold is expected to be...
(1).  ABC expects sales of $21,830,000 this year. The cost of goods sold is expected to be $12,468,000 while selling, general and admin (SGA) expenses are forecast to be $4,114,000. The firm expects depreciation expenses to be $202,000 and expects to pay an average interest rate of 4% on its $4,415,000 of liabilities. Given its tax rate of 40%, what is the expected net income for ABC this year?(If it is a negative, be sure and enter a negative sign) (2)....
Suppose that LilyMac Photography has annual sales of $237,000, cost of goods sold of $172,000, average...
Suppose that LilyMac Photography has annual sales of $237,000, cost of goods sold of $172,000, average inventories of $5,200, average accounts receivable of $26,400, and an average accounts payable balance of $7,700. Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.) Cash Cycle Days _________
Suppose that LilyMac Photography has annual sales of $221,000, cost of goods sold of $156,000, average...
Suppose that LilyMac Photography has annual sales of $221,000, cost of goods sold of $156,000, average inventories of $6,400, average accounts receivable of $28,800, and an average accounts payable balance of $19,100. Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Sales (all on account) $ 773,000 $ 607,000 Cost of goods sold 462,000 402,000 Average inventory...
Sales (all on account) $ 773,000 $ 607,000 Cost of goods sold 462,000 402,000 Average inventory during the year 130,000 120,000 Average receivables during the year 150,000 100,000 a-1. Compute the gross profit percentage for both years. (Round your percentage answers to the nearest whole number. i.e. 0.1234 as 12%.) a-2. Compute the inventory turnover for both years. (Round your answers to 1 decimal place.) a-3. Compute the accounts receivable turnover for both years. (Round your answers to 1 decimal...
Suppose that LilyMac Photography has annual sales of $232,000, cost of goods sold of $167,000, average...
Suppose that LilyMac Photography has annual sales of $232,000, cost of goods sold of $167,000, average inventories of $4,700, and average accounts receivable of $25,200. Assume that all of LilyMac’s sales are on credit. What will be the firm’s operating cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.) Operating Cycle Days ____________
Question 6. Black Current Ltd has sales of $ 935,000, Cost of goods sold of $602,000,...
Question 6. Black Current Ltd has sales of $ 935,000, Cost of goods sold of $602,000, selling expenses of $32,000, administrative expenses of $7,000, depreciation expenses of $40,000, interest expenses of $ 22,000 and corporate tax rate of 30%. Required: a) Calculate the gross profit and operating profit (EBIT) of the company? b) Build the income statement of the company and identify net income? c) If return on equity ratio of the company is 20% and number of outstanding shares...
During the current year, merchandise is sold for $8,920,000. The cost of the goods sold is...
During the current year, merchandise is sold for $8,920,000. The cost of the goods sold is $6,065,600. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. What is the amount of the gross profit? Round your answer to the nearest dollar. $   Compute the gross profit percentage (gross profit divided by sales). Round your answer to the nearest whole number. % Will the...
The Cost of Sales (or Cost of Goods Sold) is usually considered the most important cost...
The Cost of Sales (or Cost of Goods Sold) is usually considered the most important cost in hospitality businesses. How is it determined? Please select the most appropriate answer. 1. It is calculated by adding up all purchases of inventory during one accounting period. 2. It is the amount of inventory on hand. It is calculated by adding the value of every item of inventory available on hand. 3. It is calculated by adding all purchase amounts to the beginning...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT