Question: 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  please help with letters C through H , i need this
with excel formuals if possible thank you 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.

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

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 Accounting Questions!