Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Comfy Pillows makes decorative throw pillows for home use. The following information was taken from the Comfy Pillows sales budget: (Click the icon to view
Comfy Pillows makes decorative throw pillows for home use. The following information was taken from the Comfy Pillows sales budget: (Click the icon to view the first quarter sales budget.) The following information was taken from the Comfy Pillows direct materials budget: (Click the icon to view information from the direct materials budget.) Read the requirements. Assume the following additional information was gathered about the types of sales made in the fourth quarter (October through December) of the previous year: (Click the icon to view the fourth quarter sales budget.) Requirement 1. Prepare the cash collections budget for January, February, and March, as well as the summary for the first quarter. Comfy Pillows Cash Collections Budget For the Quarter Ended March 31 March 1st Quarter January 176000 February 220000 Cash sales 225500 621500 Collections on credit sales: 75% of credit sales made last month 15% of credit sales made two months ago 8% of credit sales made three months ago Total cash collections Requirement 2. Prepare the cash payments budget for direct materials purchases for the months of January, February, and March, as well as a summary for the quarter. Comfy Pillows Cash Payments Budget - Direct Materials For the Quarter Ended March 31 January February March 1st Quarter 40% of current month DM purchases 60% of last month's DM purchases Total cash payments for DM - Data Table Data Table Comfy Pillows Comfy Pillows Sales Budget: Type of Sale For the Quarter Ended March 31 Sales Budget: Type of Sale For the Quarter Ended December 31 Type of Sale: January February March 1st Quarter Type of Sale: October November December 4th Quarter Cash sales (10%) $176,000 1,584,000 $220,000 1,980,000 $225,500 2,029,500 $621,500 $5,593,500 Cash sales (10%) $ Credit sales (90%) 142,800 $ 1,285,200 137,200 $ 1,360,800 137,200 $ 1,234,800 $ 417,200 3,880,800 Credit sales (90%) $1,760,000 $2,200,000 $2,255,000 $6,215,000 Total sales revenue $ Total sales revenue 1,428,000 $ 1,372,000 $ 1,372,000 $ 4,172,000 The company's collection history indicates that 75% of credit sales is collected in the month after the sale, 15% is collected two months after the sale, 8% is collected three months after the sale, and the remaining 2% is never collected. Data Table Done Comfy Pillows Excerpt from Direct Materials Budget For the Q For the Quarter Ended March 31 Janul nt month DM purchases month's DM purchases January February March 1st Quarter $ 942,150 $ 1,109,350 $ 1,149,600 $ 3,201,100 Total cost of DM purchases Assume that the total cost of direct materials purchases in December was $725,000. The company pays 40% of its direct materials purchases in the month of purchase, and pays the remaining 60% in the month after purchase. ayments for DM
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