Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Interactive Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

5th edition

132567237, 978-0132998345, 132998343, 978-0132567237

More Books

Students also viewed these Accounting questions

Question

Understand a department managers role in locating job candidates

Answered: 1 week ago