Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you check my work to see if I came up with the correct answers? a. What are the total expected cash collections for the

Can you check my work to see if I came up with the correct answers?

a. What are the total expected cash collections for the year under this revised budget?
Answer: $1,005,000
b. What is the total required production for the year under this revised budget?
Answer: 259,500 Units
c. What is the total cost of raw materials to be purchased for the year under this revised budget?
Answer: $1,333,500
image text in transcribedimage text in transcribed \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow[t]{2}{*}{39} & \multirow[t]{2}{*}{ Construct the production budget } & \multicolumn{4}{|c|}{ Year 2 Quarter } & & \multicolumn{2}{|c|}{ Year 3 Quarter } \\ \hline & & 1 & 2 & 3 & 4 & Year & 1 & 2 \\ \hline 41 & Budgeted unit sales & 35,000 & 65,000 & 100,000 & 50,000 & 250,000 & 70,000 & 80,000 \\ \hline 42 & Add desired finished goods inventory & 16,250 & 25,000 & 12,500 & 17,500 & 17,500 & 20,000 & \\ \hline 43 & Total needs & 51,250 & 90,000 & 112,500 & 67,500 & 267,500 & 90,000 & \\ \hline 44 & Less beginning inventory & 8,000 & 16,250 & 25,000 & 12,500 & 8,000 & 17,500 & \\ \hline 45 & Required production & 43,250 & 73,750 & 87,500 & 55,000 & 259,500 & 72,500 & \\ \hline \multicolumn{9}{|l|}{46} \\ \hline 47 & Construct the raw materials purchases budget & \multicolumn{4}{|c|}{ Year 2 Quarter } & \multicolumn{3}{|c|}{ Year 3 Quarter } \\ \hline 48 & & 1 & 2 & 3 & 4 & Year & 1 & \\ \hline 49 & Required production (units) & 43,250 & 73,750 & 87,500 & 55,000 & 259,500 & 72,500 & \\ \hline 50 & Raw materials required to produce one unit & 7 & 7 & 7 & 7 & 7 & 7 & \\ \hline 51 & Production needs (pounds) & 302,750 & 516,250 & 612,500 & 385,000 & 1,816,500 & 507,500 & \\ \hline 52 & Add desired ending inventory of raw materials (pounds) & 103,250 & 122,500 & 77,000 & 101,500 & 101,500 & & \\ \hline 53 & Total needs (pounds) & 406,000 & 638,750 & 689,500 & 486,500 & 1,918,000 & & \\ \hline 55 & Raw materials to be purchased & 393,000 & 535,500 & 567,000 & 409,500 & 1,905,000 & & \\ \hline 56 & Cost of raw materials per pound & $0.70 & $0.70 & $0.70 & $0.70 & $0.70 & & \\ \hline 57 & Cost of raw materials to be purchased & $275,100 & $374,850 & $396,900 & $286,650 & $1,333,500 & & \\ \hline \multicolumn{9}{|l|}{58} \\ \hline 59 & \multicolumn{8}{|c|}{ a. What are the total expected cash collections for the year under this revised budget? } \\ \hline 60 & Answer: $1,005,000 & & & & & & & \\ \hline 6 & \multicolumn{8}{|c|}{ b. What is the total required production for the year under this revised budget? } \\ \hline 62 & Answer: 259,500 Units & & & & & & & \\ \hline 63 & \multicolumn{8}{|c|}{ c. What is the total cost of raw materials to be purchased for the year under this revised budget? } \\ \hline 6 & Answer: $1,333,500 & & & & & & & \\ \hline & & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting

Authors: Carl S. Warren, Christine Jonick, Jennifer Schneider

28th Edition

1337902683, 978-1337902687

Students also viewed these Accounting questions