Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with selling and administrative Expense budget: Additional information provided: AutoSave OFF start_file_18_keenan_Excel_3_Master_Budget_START Saved to my Mac Home Insert Draw Page Layout Formulas

I need help with selling and administrative Expense budget:

image text in transcribed

Additional information provided:

image text in transcribedimage text in transcribedimage text in transcribed AutoSave OFF start_file_18_keenan_Excel_3_Master_Budget_START Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View @ Tell me Calibri (Body) 12AA ab Wrap Text v Formatting as Table Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A3 fx A earned C 0 possible D E 21 60 cell Start File 18 Keenan M Press F9 to grade JD Music Loft Selling \& Administrative Expense Budget For the Month in Section 1: Variable Expenses Commissions Expense Variable Shipping and Handling Expense Total Variable S\&A Expenses Section 2: Fixed Expenses Fixed Shipping and Handling Expense Insurance Expense Rent Expense Depreciation Expense Utilities Expense Salaries Expense Advertising Expense Total Fixed S\&A Expenses Section 3: Cash Payments Commissions Expense Total Shipping and Handling Expense Insurance Expense Rent Expense Depreciation Expense Utilities Expense Salaries Expense Advertising Expense Total Cash Payments October November December \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline \end{tabular} > Case Beginning Balance Sheet Sales Budget Purchases Budget S\&A Exp. Budget Cash Budget Proforma Income Statement Proforma Balance Sheet Ready Q x Accessibility: Investigate - +100% 2 According to the past collection history, JD expects to collect its credit sales in the following pattern: Month of Sales 60% Month following Sales 40% 3 Inventory policy and inventory purchase payments are as follows: Cost of Goods Sold as a percentage of total Sales 75% Desired Ending Inventory as a percentage of next month COGS 25% All purchases of Inventory are on credit and the payment of these credit purchases are made in the following pattern: Month of Purchases 80% Month following Purchases 20% 4 The information on expected monthly Selling and Administrative Expenses is outlined below: (1) Sales Commissions are paid the month after they are incurred. The paid rate to total sales is (2) The combanv pavs its Shipping and Handling expense in the same month it incurred. Based on an analysis of data fror 5 The company expects to purchase a piece of land in October, paying cash for $35,000 6 The company has a line of credit from a local bank and it pays interest each month based on its beginning balance. Monthly interest rate 2% AutoSave OFF start_file_18_keenan_Excel_3_Master_Budget_START Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View @ Tell me AutoSave OFF start_file_18_keenan_Excel_3_Master_Budget_START Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View @ Tell me 5 Section 2: Cash Collections From Cash Sales From Credit Sales this month From Credit Sales last month Total Cash Collections from Customers \begin{tabular}{|lr|rr|rr|} \hline$ & 27,500 & $ & 29,125 & $ & 33,494 \\ \hline$ & 49,500 & $ & 52,605 & $ & 60,496 \\ \hline$ & 27,500 & $ & 33,000 & $ & 35,070 \\ \hline$ & 104,500 & $ & 114,730 & $ & 129,060 \\ \hline \end{tabular} \begin{tabular}{|lr|rr|rr|} \hline$ & 27,500 & $ & 29,125 & $ & 33,494 \\ \hline$ & 49,500 & $ & 52,605 & $ & 60,496 \\ \hline$ & 27,500 & $ & 33,000 & $ & 35,070 \\ \hline$ & 104,500 & $ & 114,730 & $ & 129,060 \\ \hline \end{tabular}

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

Introduction To Managerial Accounting

Authors: Peter Brewer, Ray Garrison, Eric Noreen

4th Edition

0073379352, 9780073379357

More Books

Students also viewed these Accounting questions