Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

comment (red triangle) in cell F16 in the assumptions page. Part I Check Figures Schedule 1: Total sales for year should equal $2,282,359 Schedule

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

comment (red triangle) in cell F16 in the assumptions page. Part I Check Figures Schedule 1: Total sales for year should equal $2,282,359 Schedule 2: Total cash collected in Q1 is equal to $410,569. Total cash collected for the year is $2,094,258. Schedule 3: total units produced for the standard table in Q2 is 2,089. Schedule 4: Total cost of direct materials for Q2 is equal to $216,294. units Ending inventory Qtr 3 for standard table wood = 5058 Schedule 5: Total cash paid for materials purchases in Q2 is equal to $211,219. Schedule 6: total cash paid for direct labor for the year = $642,900 Schedule 7: Total MOH (fixed and variable) = 365,305 Schedule 8: total budgeted variable expenses for the year = 161,698 Total budgeted fixed expenses = 176,000 Schedule 9: Ending line of credit balance Qtr 1 = 171,770. Total financing (borrowing) for Q2 $50,498. Interest payment for Q3=$4,445. Ending credit line balance for Q4 equals $237,231. Schedule 10: Cost of goods sold 1,853,188. Interest expense equal to $17,532. Schedule 11: Total assets equal $1,123,013.

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

Accounting Information Systems

Authors: Marshall B. Romney, Paul J. Steinbart

13th edition

133428532, 978-0133428537

More Books

Students also viewed these Accounting questions