Answered step by step
Verified Expert Solution
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
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
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