Question: please help how do i set this up its the last part i have w ch A == WE 99 og coboard $ % 13

please help how do i set this up its the last part i have
please help how do i set this up its the last part
i have w ch A == WE 99 og coboard $ %

w ch A == WE 99 og coboard $ % 13 Coral Format Forys Stele Sorld finds ed 92 A B D Cost per case 5 4.80 2.16 $ 0.00 04 02 s 504,000.00 900000 84 direct materials (4 pounds per pack $1 20 per pack) BS direct labor (0.12 hours per 518 per hour) 86 Variable MOH 87 Indirect materials (50 60 per case) BB Indirect labor($0.40 per case) 89 Variable Utilities (50.20 per case) 90 Total variable MOH per case 91 Foxed MOH ( 42000 per month 12 months) 42 divided by Budgeted production volume cases) 93 Total fixed MOH per case 94 Cost per case(absorption costing) 95 96 Budget Income Statement 97 (for the Quarter ended June 30) 98 99 100 101 102 Assumptions Budgets $ $ 0.56 7.52 ET Type here to search E 43F OD 40 11:20 PM 4/18/2022 8. Prepare a Budgeted Income Statement for the quarter for Pickachip Assume interest expense of $0, and income tax expense of 22% of income before taxes. Pickachip's goal for the quarter is to make its not income greater than 10% of its sales revenue. To determine whether the company achieves the goal, use @IF function. In the IF function, you need to label "Achieved" if it achieves the goal (if the condition is met) or "Not Achieved" if it does not achieve (if the condition is not met). Use the CELL right next to "Net Income' cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue*10%) is met or not. w ch A == WE 99 og coboard $ % 13 Coral Format Forys Stele Sorld finds ed 92 A B D Cost per case 5 4.80 2.16 $ 0.00 04 02 s 504,000.00 900000 84 direct materials (4 pounds per pack $1 20 per pack) BS direct labor (0.12 hours per 518 per hour) 86 Variable MOH 87 Indirect materials (50 60 per case) BB Indirect labor($0.40 per case) 89 Variable Utilities (50.20 per case) 90 Total variable MOH per case 91 Foxed MOH ( 42000 per month 12 months) 42 divided by Budgeted production volume cases) 93 Total fixed MOH per case 94 Cost per case(absorption costing) 95 96 Budget Income Statement 97 (for the Quarter ended June 30) 98 99 100 101 102 Assumptions Budgets $ $ 0.56 7.52 ET Type here to search E 43F OD 40 11:20 PM 4/18/2022 8. Prepare a Budgeted Income Statement for the quarter for Pickachip Assume interest expense of $0, and income tax expense of 22% of income before taxes. Pickachip's goal for the quarter is to make its not income greater than 10% of its sales revenue. To determine whether the company achieves the goal, use @IF function. In the IF function, you need to label "Achieved" if it achieves the goal (if the condition is met) or "Not Achieved" if it does not achieve (if the condition is not met). Use the CELL right next to "Net Income' cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue*10%) is met or not

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!