Question

In: Accounting

Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made...

Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year:

Month Sales Purchases Cash Expenses Paid
May $ 94,000 $ 66,000 $ 18,000
June 122,000 92,000 25,500
July 139,000 117,000 32,750
August 125,000 71,000 32,900


The majority of Martin’s sales (70 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin’s purchases are on account with 55 percent paid in the month of purchase and 45 percent paid the following month.

Required:
1.
Determine budgeted cash collections for July and August.

2. Determine budgeted cash payments for July and August. ​

Solutions

Expert Solution

1

July August
Cash received from cash sales $139,000*70% = $97,300 $125,000*70% = $87,500
Cash received from credit sales
June sales $122,000*30%*35% = $23,790
July sales $139,000*30%*35% = $14,595 $139,000*30%*65% = $27,105
August sales $125,000*30%*35% = $13,125
Total cash collected $                                            135,685 $                                            127,730

2.

July August
Cash paid for June purchases $92,000*45% = $41,400
Cash paid for July purchases $117,000*55% = $64,350 $117,000*45% = $52,650
Cash paid for August purchases $71,000*55% = $39,050
Cash expenses paid $                                   32,750 $                                   32,900
Total cash paid $                                 138,500 $                                 124,600

You can reach me over comment box if you have any doubts. Please rate this answer


Related Solutions

Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 95,000 $ 68,000 $ 23,000 June 116,000 87,000 26,000 July 137,000 115,000 36,000 August 134,000 79,000 30,800 The majority of Martin’s sales...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 97,000 $ 65,000 $ 21,000 June 123,000 91,000 25,000 July 132,000 116,000 37,500 August 125,000 77,000 30,100 The majority of Martin’s sales...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 93,000 $ 68,000 $ 20,000 June 122,000 85,000 25,000 July 130,000 112,000 34,500 August 130,000 79,000 35,000 The majority of Martin’s sales...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 94,000 $ 60,000 $ 22,000 June 120,000 85,000 28,500 July 133,000 117,000 32,500 August 133,000 73,000 29,400 The majority of Martin’s sales...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made...
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month Sales Purchases Cash Expenses Paid May $ 99,000 $ 70,000 $ 21,000 June 122,000 90,000 26,500 July 139,000 117,000 34,000 August 128,000 72,000 29,400 The majority of Martin’s sales...
Ajax Company is a large retail company that sells clothing, shoes, and other apparel. It has...
Ajax Company is a large retail company that sells clothing, shoes, and other apparel. It has 40 retail outlets located in 22 states. All of the merchandise if purchased by a centralized procurement organization located at the company’s corporate headquarters. There are six purchasing agents with each agent assigned to purchase different types of goods. Each agent works independently with suppliers to get the best deals for the company. The six agents report to the purchasing director. The director oversees...
Values Rule at Patagonia Patagonia is a California-based company that makes clothing and gear for outdoor...
Values Rule at Patagonia Patagonia is a California-based company that makes clothing and gear for outdoor sports like hiking and climbing. It has been called “The Coolest Company on the Planet” and it has a consistent track record of being voted one of the best companies to work for. Patagonia employees are among some of the most passionate and long serving in the industry. In fact, with an annual turnover rate of only 4 percent, so few people leave the...
Patagonia Patagonia sells rugged clothing and gear to mountain climbers, skiers, and other extreme-sport enthusiasts. The...
Patagonia Patagonia sells rugged clothing and gear to mountain climbers, skiers, and other extreme-sport enthusiasts. The company is also well known for its environmental stands and its commitment to product quality. Patagonia has never owned a fabric mill or a sewing shop. Instead, to make a ski jacket, for example, it buys fabric from a mill, and zippers and facings from other manufacturers, and then hires a sewing shop to complete the garment. To meet its own environmental standards and...
Land's Bend sells a wide variety of outdoor equipment and clothing. The company sells both through...
Land's Bend sells a wide variety of outdoor equipment and clothing. The company sells both through mail order and via the internet. Random samples of sales receipts were studied for mail-order sales and internet sales, with the total purchase being recorded for each sale. A random sample of 1616 sales receipts for mail-order sales results in a mean sale amount of $72.50$⁢72.50 with a standard deviation of $20.75$⁢20.75. A random sample of 77 sales receipts for internet sales results in...
K.Brew sells a wide variety of outdoor equipment and clothing. The company sells both through mail...
K.Brew sells a wide variety of outdoor equipment and clothing. The company sells both through mail order and via the internet. Random samples of sales receipts were studied for mail-order sales and internet sales, with the total purchase being recorded for each sale. A random sample of 14 sales receipts for mail-order sales results in a mean sale amount of $80.40 with a standard deviation of $24.75. A random sample of 10 sales receipts for internet sales results in a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT