Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Lineberry Golf Cart Co. sold 7,400 carts this year at an average unit price of $3,000. The firm produced the carts at a 44%
The Lineberry Golf Cart Co. sold 7,400 carts this year at an average unit price of $3,000. The firm produced the carts at a 44% cost ratio, which is calculated as cost of goods sold (COGS) divided by revenue. At year end, 45 days of sales remained uncollected accounts receivable, and three months of inventory was on hand (a month of inventory is 1/12 of the year's COGS), The golf cart business is booming and management plans a 8% increase in unit sales despite a 6% price increase. The firm has programs in place to improve production efficiency, inventory management, and the effectiveness of collection efforts. It is assumed that these programs will decrease the cost ratio to 40%, lower year-end inventory to two months, and lower year-end receivables to 40 days of sales. Use the format below to develop this year's and next year's revenue and cost of goods sold (COGS) and year ending balance for accounts receivable and inventory. Calculate using a 360-day year and assume sales are evenly distributed over the year. Round your answers for cost ratio in decimals to two decimal places and all other answers to the nearest whole number. This Year Next Year's Plan Units Unit Price $ $ Revenue: S $ Cost ratio COGS: 5 $ Days sales in A/R A/R balance: $ $ Months of Inventory on hand Inventory Balance s $ The Lineberry Golf Cart Co. sold 7,400 carts this year at an average unit price of $3,000. The firm produced the carts at a 44% cost ratio, which is calculated as cost of goods sold (COGS) divided by revenue. At year end, 45 days of sales remained uncollected accounts receivable, and three months of inventory was on hand (a month of inventory is 1/12 of the year's COGS), The golf cart business is booming and management plans a 8% increase in unit sales despite a 6% price increase. The firm has programs in place to improve production efficiency, inventory management, and the effectiveness of collection efforts. It is assumed that these programs will decrease the cost ratio to 40%, lower year-end inventory to two months, and lower year-end receivables to 40 days of sales. Use the format below to develop this year's and next year's revenue and cost of goods sold (COGS) and year ending balance for accounts receivable and inventory. Calculate using a 360-day year and assume sales are evenly distributed over the year. Round your answers for cost ratio in decimals to two decimal places and all other answers to the nearest whole number. This Year Next Year's Plan Units Unit Price $ $ Revenue: S $ Cost ratio COGS: 5 $ Days sales in A/R A/R balance: $ $ Months of Inventory on hand Inventory Balance s $
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