Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help with letters C through H , i need this with excel formuals if possible thank you The focts for this problem ore presinted

please help with letters C through H , i need this with excel formuals if possible thank you image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The focts for this problem ore presinted on the Facts tab of this woribonk. Instructiont - Your solutions shouls be clearly lobeled on the solvelions tab of thy workboct. For the firt quarter of 2022, do the following. (a) Prepare a sales budget. This is imilor to lilloitroilion 223 in rour terrbook. You wall need to prepere wchedbile for expected pellection thom custemeri. Aules Aoines are bost for not following these nule. - Use Eacela functionality to vour betheft. Use formulas. - Use corect number lormass is. Ki senerag and understorine where agproperiase. - Double eheck year work Veritu phe formues and inciel The company is preparing its budget for the coming year, 2022. The first step is to plan for the first quarter of that coming year. The following Information has been gathered from their managers. Grading guidelines are on the instructions tab. The com pany likestoktery Planning 41 Manufacturing Overhead Costs 42 Variable costs per direct lobor hour 47 Fixed costs per month 48 Salaries \begin{tabular}{|l|l|} \hline 49 & Depreciation \\ \hline 50 & Property taxes \\ \hline 51 & Insurance \\ \hline 52 & Janitorial \\ \hline 53 & \\ \hline 54 & Selling and Administrative Costs \\ \hline \end{tabular} 42,00016,8002,6751,2001,300 S5 Variable costs per unit sold 56 Fixed costs per month 63 Income Taxes 64 Accrued on Monthly Net income 35% rounded to nearest dollar 65 Amounts Accrued Q42021 paid January 2022 66 67 Cash and Financing Matters 68 Cach Balance, 12/31/2021 692022 Minimum Balance Required 70 71 Monthly Dividends 72 Outstanding Shares 73 Line of Credit 75 Limit 76 Borrowing increment Required 77 Annual interest Rate 78 Borrowings occur on the 81 82 Additional Item 83 Fixed Asset Purchase $400,000 84 Month February

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

Principles Of Cost Accounting

Authors: Edward J. Vanderbeck

15th Edition

978-0840037039, 0840037031

More Books

Students also viewed these Accounting questions

Question

=+What can we learn about the PVA data from this decision tree?

Answered: 1 week ago