Answered step by step
Verified Expert Solution
Question
1 Approved Answer
32 K ces Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: Revenues April $253,000 $272,000 May June $291,000
32 K ces Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: Revenues April $253,000 $272,000 May June $291,000 July $342,000 August $351,000 Carmen's sales are 70% cash and 30% store credit. The credit sales are collected 70% in the month of sale, the remainder the following month. Accounts receivable on April 1 are $40,000. Carmen's cost of sales averages 70% of revenues. The inventory policy is to carry 30% of next month's sales needs. April 1 inventory will be as expected under the policy. Carmen pays for purchases 40% in the month of purchase and 60% the following month. Accounts payable on April 1 is $128,000. a. Prepare a purchases budget for as many months as is possible. Sales Cost of Sales Percentage Cost of Sales Ending Inv Beginning Inv Purchases From This Month From Last Month Cash Payments April $ 253,000 $ April b. Prepare a cash payments budget for April through July. May Cash Sales Collected in the Month of Sale Collected the Following Month Cash Collected % May 272,000 April June June July $ 291,000 $ 342,000 May July c. Prepare a cash receipts budget for April through July. (Do not round intermediate calculations.) % June % July August $ 351,000 %
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