Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help me to calculate the CVP income statement guys. Thanks Additional details: - Fine Office Company produces two products P100 and P200 - Sales price

image text in transcribed

image text in transcribed

image text in transcribed

help me to calculate the CVP income statement guys. Thanks

Additional details: - Fine Office Company produces two products P100 and P200 - Sales price per P100 is - Sales price per P200 is - The value of P100 finished goods inventory at the end of 2022 is \begin{tabular}{|r|} \hline$1,200 \\ \hline$1,400 \\ \hline$360,000 \\ \hline \end{tabular} - At the end of each quarter, Fine Office Company requires ending inventory to be equal to The value of P200 finished goods inventory at the end of 2022 is 11% of the following quarter's budgeted sales in units. - Each P100 unit uses Each P200 unit uses \begin{tabular}{|l|l} \cline { 1 - 2 } 114 & sq. ft. of steel during the manufacturing process. The cost of steel for 2023 is estimated to be \\ \cline { 1 - 2 } 152 & sq. ft. of steel during the manufacturing process. \end{tabular} - Fine Office Company currently has $8 per sq. ft. the end of each quarter, Fine Office Company wants to have 91,200 sq. ft. of ending inventory. - Each product requires - Direct Labour costs $ \begin{tabular}{|r|l|l|l} \hline 2 & machine hours and & 7 & direct labour hrs to produ \\ \hline 19.7 & per direct labour hour. & \end{tabular} - Fine Office Company allocates manufacturing overhead costs based on the estimated machine hours. Estimated manufacturing overhead cost for 2023 are $143,640 and are all variable. - For each quarter, it is estimated that will be credit sales. Of the credit sales, 80% pay in the quarter of the sale and 20% pay in the following quarter. Credit sales from Q4 2022 were - Direct labour costs and manufacturing overhead costs are paid for in cash in the quarter they occurred. - Assume operating expenses occur evenly throughout the year and are all paid in cash. - For each quarter, the purchase and Q4 2022 were \begin{tabular}{|r|r|} \hline 70% & of material purchases are paid for in cash in the quarter of \\ \hline 30% & are paid in the following quarter. Purchases of materials from \\ \hline$1,500,000 & \end{tabular} Assume operating expenses occur evenly throughout the year and are all paid in cash. For each quarter, the purchase and Q4 2022 were \begin{tabular}{|r|} \hline 70% \\ \hline 30% \\ \hline 1,500,000 \\ \hline \end{tabular} Fine Office Company Additional details continued: - Fine Office Company will pay $60,000 in dividends in Q4 - Currently, the cash balance in the bank is $15,000. Fine Office Company wants to maintain a minimum cash balance of $10,000 in the bank for each quarter. - Budgeted sales volumes year 2024 Q1: \begin{tabular}{rr|r|} \hline P100 & Q1 & 9804 \\ \hline P200 & Q1 & 10488 \\ \hline \end{tabular} - Budgeted sales volumes are: \begin{tabular}{|l|l|l|l|l|l|l|l|} \hline P100 & Q1 & 10260 & Q2 & 10944 & Q3 & 11764 \\ \hline P200 & Q1 & 12585 & Q2 & 11764 \\ \hline \end{tabular} - Selling and Administration expenses for the budgeted year are as follows: Variable Cost: Fixed Costs per quarter: Accounting \& professional services Administrative \& Sales Salaries Advertising Instructions Sales Budget Sroduction Budget Pirect materials Budget \begin{tabular}{lll|l|} \hline \multicolumn{2}{l|}{ CVP Income Statement for vear ended 31st December 2023 } \\ 9 & & $ & \\ \hline & Sales & & \\ \hline & Less: Variable Costs & \\ \hline & Direct materials & & \\ \hline & Direct Labour & & \\ \hline 4 & Manufacturing Variable Overhead costs & \\ 5 & Selling \& Administration variable costs & \\ 6 & Adjustment for Finished Inventory & & \\ 7 & Beginning Finished Goods Inventory & & \\ 8 & Less: Ending Finished Goods Inventory & & \\ 9 & Total Contribution Margins & & \\ \hline 0 & Less: Fixed costs & & \\ \hline 1 & Selling \& Administration fixed costs & & \\ 2 & Interest costs & & \\ 3 & Income Tax & & \\ \hline 4 & Net Income after taxation & & \\ \hline 5 & & & \\ \hline \end{tabular} Check result with Income Statement

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

Financial Accounting an introduction to concepts, methods and uses

Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis

13th Edition

978-0538776080, 324651147, 538776080, 9780324651140, 978-0324789003

More Books

Students also viewed these Accounting questions