Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Mountaineers sells its rock-climbing shoes worldwide. Mountaineers expects to sell 4,000 pairs of shoes for $165 each in January, and 2,000 pairs of shoes
3. Mountaineers sells its rock-climbing shoes worldwide. Mountaineers expects to sell 4,000 pairs of shoes for $165 each in January, and 2,000 pairs of shoes for $220 each in February. All sales are cash only. Requirement Prepare the sales budget for January and February. 4. Review your results from exercise 3. Mountaineers expects cost of goods sold to average 75% of sales revenue, and the company expects to sell 4,600 pairs of shoes in March for $240 each. Mountaineers target ending inventory is $18,000 plus 45% of the next months cost of goods sold. Requirement R1. Use this information and the sales budget prepared in S21-3 to prepare Mountaineers inventory, purchases, and cost of goods sold budget for January and February. 5. Refer to the Mountaineers sales budget that you prepared in exercise 3. Now assume that Mountaineers sales are 20% cash and 80% on credit. Mountaineers collection history indicates that credit sales are collected as follows: 30% of month in sales 60% of month after the sale 7% two months after the sale 3% never collected 6. Mountaineers has $8,600 cash on hand on December 1. The company requires a minimum cash balance of $7,400. December cash collections are $548,600. Total cash payments for December are $563,230. Requirement Prepare a cash budget for December. Will Mountaineers need to borrow cash by the end of December? November sales totaled $386,000 and December sales were $399,500. Requirement Prepare a schedule for the budgeted cash collections for January and February
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started