Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

asap please i have done it all i just need to make sure it is right. please answer them for me dont explain as i

asap please
i have done it all i just need to make sure it is right. please answer them for me dont explain as i do understand i just need to make aure of my work.
image text in transcribed
image text in transcribed
image text in transcribed
Part 1 relates to Module 22 make sure you take time to Review 224, which also has a video in MBC that walks you through the review. I haw budgot support materal in the Module 22 folder in the course Computer Accessones assembies a computer networkang device from kits of imported components. You have been asked to dewilop a quarterfy and annual operating budget and a pro-forma income stalements for the year ending December 31,20x You haw oblainod the following infornation I have a ternplate set up on the PartiBudgetSolution workshoet that you showh ure to complete the roquired budgots You need to use cell references in the development of your budgets. You must use this worksheet to reference the data that is being inputted onto the budgets on the budget worksheet. If you type in any numbers in the solution, I will take off 5 pts for each cell that has a number typed in the cell. You should use this worksheet as your data ficld and only une ced refercnces and formulas in your budgets The beauty behind excel is that managers can perform what-if analysers jest by changing the data, so you do not noed to retype the budgots if you have used cell references and formulas throughout elling and administrative costs are paid in quarter incurred uniess it is an noncash exnence Fequired: Prepare and answer the following. Make sure you use cell referencing Hint Please note that the annual total, does not necessanly mean that you should add across, for example, feview exhiba 22 . 13 sunce desired ending inventory is the invertery at the end of the period and beginning mventery is the beginning inventory at the beginning of the period. 1. A saces bodget foc each quanter and the year 2 A production budyet tor tinched gooss of units each quarter and the year 3. A purchases budget for rou maleras of his each qualiet and the year 4. A exnutactuang cost buoget tor each cuarer and the year 8. A cast oudget lor each quanter and the year. 1 pint You wis need to compute varabie Cest of Coods Sold for each euarter, which is unit soid times total variabie standard cost per unht. a

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

Understanding Corporate Annual Reports

Authors: William Pasewark

7th Edition

0073526932, 9780073526935

More Books

Students also viewed these Accounting questions