Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: April...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: April May June July August Revenues. $ 256,000 $ 266,000 $ 291,000 $ 347,000 $ 358,000 Carmen's sales are 80% cash and 20% store credit. The credit sales are collected 50% in the month of sale, the remainder the following month. Accounts receivable on April 1 are $38,000. Carmen's cost of sales averages 60% 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 30% in the month of purchase and 70% the following month. Accounts payable on April 1 is $132,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 % May % June % July % August % b. Prepare a cash payments budget for April through July. From This Month From Last Month Cash Payments $ April Cash Sales Collected in the Month of Sale Collected the Following Month Cash Collected 0 $ May $ 0 $ April June c. Prepare a cash receipts budget for April through July. (Do not round intermediate calculations.) 0 $ 0 $ May July 0 0 $ June 0 $ July Carmen is a retailer of scrapbooking products. The sales forecast for the coming months is: April May June July August Revenues. $ 256,000 $ 266,000 $ 291,000 $ 347,000 $ 358,000 Carmen's sales are 80% cash and 20% store credit. The credit sales are collected 50% in the month of sale, the remainder the following month. Accounts receivable on April 1 are $38,000. Carmen's cost of sales averages 60% 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 30% in the month of purchase and 70% the following month. Accounts payable on April 1 is $132,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 % May % June % July % August % b. Prepare a cash payments budget for April through July. From This Month From Last Month Cash Payments $ April Cash Sales Collected in the Month of Sale Collected the Following Month Cash Collected 0 $ May $ 0 $ April June c. Prepare a cash receipts budget for April through July. (Do not round intermediate calculations.) 0 $ 0 $ May July 0 0 $ June 0 $ July
Expert Answer:
Answer rating: 100% (QA)
a Prepare a Purchases budget Sales Cost of Sales Percentage Cost of Sales Add Ending Inventory Less Beginning Inventory Purchases April Purchases budg... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Procedures Experiment 1: Standardize the Iodine Solution Part 1: Prepare the Materials Take a 100 mL volumetric flask from the Containers shelf and place it on the workbench. Take ascorbic acid from...
-
Procedures Experiment 1: Standardize the Iodine Solution Part 1: Prepare the Materials Take a 100 mL volumetric flask from the Containers shelf and place it on the workbench. Take ascorbic acid from...
-
Solution A was prepared by dissolving potassium acetate in methanol. Solution B was prepared by adding potassium methoxide to acetic acid. Reaction of methyl iodide either with solution A or with...
-
What responsibilities can a Crew Boss delegate to a subordinate supervisor? (Select all that apply) Re-supplying crew and equipment Communicating crew wake up time for next operational period...
-
What are right-to-work laws? How do they influence locational decisions?
-
Selected transactions of the Shadrach Computer Corporation during November and December of 2007 are as follows: Nov. 1 Borrowed money from the bank by issuing a non-interest-bearing, $40,000, 90-day...
-
A firm buys a fixed asset for 10,000. The firm estimates that the asset will be used for 5 years. After exactly 24 years, however, the asset is suddenly sold for 5,000. The firm always provides a...
-
Eisler Corporation issued 2,000 $1,000 bonds at 101. Each bond was issued with one detachable stock warrant. After issuance, the bonds were selling in the market at 98, and the warrants had a market...
-
Current Attempt in Progress Cullumber Bus Lines uses the units-of-activity method in depreciating its buses. One bus was purchased on January 1, 2025, at a cost of $131,000. Over its 4-year useful...
-
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 1 spring, and 4 clamps. The base is assembled from 1 clamp...
-
Which one is the anser? The most common cost accounting systme are: 1. Job-Order Cost System and Process Cost System. 2. Job-Order Cost System and Project Cost System. 3. Job-Order Cost System and...
-
Lowe's sells a snow shovel for $39.90. The dollar amount of markup on the shovel is $7.98. Round all dollar values to two decimal places and percentages to two decimals (i.e. 34.56%). a. What is the...
-
How can social network analysis be utilized to understand the interconnectedness of individuals within groups, and how does network structure influence information flow and influence diffusion ?
-
Write a program to find properties of a group of numbers. Please Enter the total number of group's member please enter 1. number: 12 please enter 2. number: 56 please enter 3. number: -90 : 6 please...
-
Required information [The following information applies to the questions displayed below.] Aaron, Deanne, and Keon formed the Blue Bell General Partnership at the beginning of the current year. Aaron...
-
How would you plan to learn more about the health care system and the role of nurses in another country? What are critical elements in the sustainability of global health efforts? You are considering...
-
1. Se depositan 50,000 lempiras en una cuenta que paga una tasa de inters del 6?% anual capitalizable mensualmente cul ser el monto en cuatro aos?. Se depositan 50,000 lempiras en una cuen...
-
Let (X. A. p) be a measure space. Show that for any A,B A, we have the equality: (AUB)+(An B) = (A) + (B).
-
In 1998, the Board of Directors of Lively Plays Inc. fired George Drewerson, the co- founder and another senior management representative of the company, claiming that they had engaged in fraudulent...
-
Garth Cooks Company has a book net worth of \($7,500\). Long-term debt is \($1,500.\) Net working capital, other than cash, is \($2,250\). Fixed assets are \($2,000.\) How much cash does the company...
-
Pags Products has projected the following sales for the coming year: Sales in the year following this one are projected to be 15 percent greater in each quarter. a. Calculate payments to suppliers...
Study smarter with the SolutionInn App