Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Among the items it manufactures Jefferson Wine Accessories ( JWA ) produces drink coasters. In FY 2 0 2 2 JWA sold 3 2 ,

Among the items it manufactures Jefferson Wine Accessories (JWA) produces drink coasters. In FY2022 JWA sold 32,000 packages per month containing four coasters each for $15.00 per package. JWA expects to increase the number packages sold per month by 5% per year in FY2023. The sales price per package is expected to increase to $16.00 for FY2023. JWA targets ending finished goods inventory for each month to equal 30,000 packages in FY2023. As the company is preparing its FY2023 budget it anticipates its ending Finished Goods inventory for FY2022 to equal 25,000 packages.
Each package requires 0.5 pound of cork. At the end of FY2022, management expects to have 30,000 pounds of cork in raw materials inventory. JWA targets to have raw material stocks of cork equal to 50,000 pounds at the end of each month during FY2023. JWA anticipates the cost of cork to average $9.00 per pound for the year.
JWA's sales of coasters are all done through distributors. JWA collects 75% of its sales revenue in the month of the sale and 23% in the month following the sale. 2% of gross sales are written off as bad-debts each month. On 12/31/2022 JWA anticipates having an Accounts Receivable balance of $120,000.
JWA's cork suppliers are paid 80% of monthly purchase costs in the month of the purchase and 20% in the month following the purchase. On 12/31/2022 JWA estimates its Accounts Payable balance to be $64,000.
Question 1-Compute the total number of packages budgeted to be sold in FY2023.
Question 2-Compute the total number of packages budgeted to be manufactured in January of FY2023.
Question 3-Compute the total pounds of cork budgeted to be used in production during January of FY2023.
Question 4-Compute the total pounds of cork budgeted to be purchased in January FY2023.
Question 5-Compute the cork purchasing budget for January FY2023.
Question 6-What is the budgeted amount of cash to be collected in January 2023?(Include collections from sales in both January and prior months)
Question 7-What is the budgeted amount of Sales made in January to be collected in February 2023?
Question 8-What is the budgeted amount of cash to be paid in January 2023?(Include payments from both purchases in January and prior months)
Question 9-What is the budgeted amount of inventory purchases made in January to be paid in February 2023?
Question 10-What is the budgeted January 2023 net cash flow from purchases of Raw Materials and Sales of coasters? Let a positive number represent an increase in cash and a negative number represent a decrease in cash flow.

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

Intermediate Accounting

Authors: David Spiceland

11th Edition

1264134525, 9781264134526

More Books

Students also viewed these Accounting questions