ACCOUNTING: What the Numbers Mean, 10eChapter 14 Problem 14.24 Name: Enter NameProblem Description:Freese, Inc. is in the process of preparing the fourth quarter budget for 2013, and the following data have been assembled: The company sells a single product at a selling price of $60 per unit. The estimated sales volume for the six months is as follows:UnitsSeptemberOctoberNovemberDecemberJanuaryFebruary13,00012,00014,00020,0009,00010,000 All sales are on account. The company’s collection experience has been that 32% of a month’s sales are collected in the month of sale, 64% in the month following the sale, and 4% are uncollectible. According to the budget, the net realizable value of accounts receivable (i.e. accounts receivable less allowance for uncollectible accounts) is expected to be $499,200 on September 30, 2013. Management’s policy is to maintain ending finished goods inventory each month at a level equal to 40% of the next month’s budgeted sales. The finished goods inventory on September 30, 2013, is expected to be 4,800 units. To make one unit of finished product, 5 pounds of raw material are required. Management’s policy is to have enough materials on hand at the end of each month to equal 30% of the next month’s estimated usage. The raw materials inventory is expected to be 19,200 pounds on September 30, 2013. The cost per pound of material is $4, and 70% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. The accounts payable for raw material purchases is expected to be $75,960 on September 30, 2013.Instructions:Please proceed to the “Analysis” worksheet and complete the basic problem requirements. Complete the problem requirements by entering appropriate amounts or formulas in shaded worksheet cells:a. Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2013.b. Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2013.c. Prepare a production budget in units, by month and in total, for the fourth quarter of 2013.d. Prepare a materials purchases budget in pounds, by month and in total, for the fourth quarter of 2013.e. Prepare a schedule of cash payments for materials, by month and in total, for the fourth quarter of 2013.After completing the “Analysis” worksheet, please proceed to the “What the Numbers Mean” worksheet and respond to the additional requirements presented.ACCOUNTING: What the Numbers Mean, 10eChapter 14 Problem 14.24Name: Enter NameComplete the Modeling:a. Sales BudgetSeptemberQuarter Ended December 31, 2013JanuaryExpected sales in units:OctoberNovemberDecemberTotalSelling price per unit:Total Sales:b. Cash Collections from:Quarter Ended December 31, 2013Sales% CollectedOctoberNovemberDecemberTotalSeptember sales:$-$-October sales:$–October sales:$–November sales:$–November sales:$–December sales:$–Total cash collections:$-$-$-$-c. Production BudgetQuarter Ended December 31, 2013Finished Goods% BudgetedOctoberNovemberDecemberTotalJanuaryBeginning Inventory:4,800Units to be produced:(4,800)—-Goods available for sale:—–Desired ending inventory:Quantity of goods sold:—–d. Materials Purchases BudgetOctoberNovemberDecemberTotalJanuaryUnits to be produced:(4,800)—-Pounds required for each unit:Total pounds used in production:Raw Materials% BudgetedQuarter Ended December 31, 2013OctoberNovemberDecemberTotalBeginning Inventory:19,200Purchases of materials:(19,200)—Materials available for use:—-Desired ending inventory:Total pounds used in production:—-e. Cash Payments for:OctoberNovemberDecemberTotalPurchases of materials:(19,200)—Cost per pound of raw material:Total cost of raw material purchases:Purchases% PaidQuarter Ended December 31, 2013OctoberNovemberDecemberTotalSeptember Net A/P:$75,960$75,960October purchases:$–October purchases:$–November purchases:$–November purchases:$–December purchases:$–Total cash payments:$75,960$-$-$75,960FebruaryACCOUNTING: What the Numbers Mean, 10eChapter 14 Problem 14.24 Name: Enter NameWhat does it mean? Question 1:Assume that Freese, Inc. decided that because of strong economic conditions in general, a 10% increase in the expected number of units to be sold each month was realistic. Explain the effect, in general, on each of the budgets presented of a 10% increase in the number of units sold.What does it mean? Question 2:Assuming that the number of units sold would not change, explain the effect on the budgets presented of a 5% increase in the selling price of the product. How does this price change effect differ from the sales volume effect you described above?What does it mean? Question 3:The purchasing manager is evaluating an alternative supplier that would provide a slightly lower grade of raw material at a savings from the current price of $4 per pound. The new price would be at $3.50 per pound but the product would now require six pounds of the lower grade of raw material to produce the same number of good finished units as currently achieved. Would you recommend the change to the new supplier? What if the new price was to be $3.00? How about a price of $3.285307? Explain your answers.ACCOUNTING: What the Numbers Mean, 10eChapter 14 Problem 14.24 Name: Enter NameProblem Description:Freese, Inc. is in the process of preparing the fourth quarter budget for 2013, and the following data have been assembled: The company sells a single product at a selling price of $60 per unit. The estimated sales volume for the six months is as follows:UnitsSeptemberOctoberNovemberDecemberJanuaryFebruary13,00012,00014,00020,0009,00010,000 All sales are on account. The company’s collection experience has been that 32% of a month’s sales are collected in the month of sale, 64% in the month following the sale, and 4% are uncollectible. According to the budget, the net realizable value of accounts receivable (i.e. accounts receivable less allowance for uncollectible accounts) is expected to be $499,200 on September 30, 2013. Management’s policy is to maintain ending finished goods inventory each month at a level equal to 40% of the next month’s budgeted sales. The finished goods inventory on September 30, 2013, is expected to be 4,800 units. To make one unit of finished product, 5 pounds of raw material are required. Management’s policy is to have enough materials on hand at the end of each month to equal 30% of the next month’s estimated usage. The raw materials inventory is expected to be 19,200 pounds on September 30, 2013. The cost per pound of material is $4, and 70% of all purchases are paid for in the month of purchase; the remainder is paid in the following month. The accounts payable for raw material purchases is expected to be $75,960 on September 30, 2013.Instructions:Please proceed to the “Analysis” worksheet and complete the basic problem requirements. Complete the problem requirements by entering appropriate amounts or formulas in shaded worksheet cells:a. Prepare a sales budget in units and dollars, by month and in total, for the fourth quarter (October, November, and December) of 2013.b. Prepare a schedule of cash collections from sales, by month and in total, for the fourth quarter of 2013.c. Prepare a production budget in units, by month and in total, for the fourth quarter of 2013.d. Prepare a materials purchases budget in pounds, by month and in total, for the fourth quarter of 2013.e. Prepare a schedule of cash payments for materials, by month and in total, for the fourth quarter of 2013.After completing the “Analysis” worksheet, please proceed to the “What the Numbers Mean” worksheet and respond to the additional requirements presented.ACCOUNTING: What the Numbers Mean, 10eChapter 14 Problem 14.24Name: Enter NameComplete the Modeling:a. Sales BudgetSeptemberQuarter Ended December 31, 2013JanuaryExpected sales in units:OctoberNovemberDecemberTotalSelling price per unit:Total Sales:b. Cash Collections from:Quarter Ended December 31, 2013Sales% CollectedOctoberNovemberDecemberTotalSeptember sales:$-$-October sales:$–October sales:$–November sales:$–November sales:$–December sales:$–Total cash collections:$-$-$-$-c. Production BudgetQuarter Ended December 31, 2013Finished Goods% BudgetedOctoberNovemberDecemberTotalJanuaryBeginning Inventory:4,800Units to be produced:(4,800)—-Goods available for sale:—–Desired ending inventory:Quantity of goods sold:—–d. Materials Purchases BudgetOctoberNovemberDecemberTotalJanuaryUnits to be produced:(4,800)—-Pounds required for each unit:Total pounds used in production:Raw Materials% BudgetedQuarter Ended December 31, 2013OctoberNovemberDecemberTotalBeginning Inventory:19,200Purchases of materials:(19,200)—Materials available for use:—-Desired ending inventory:Total pounds used in production:—-e. Cash Payments for:OctoberNovemberDecemberTotalPurchases of materials:(19,200)—Cost per pound of raw material:Total cost of raw material purchases:Purchases% PaidQuarter Ended December 31, 2013OctoberNovemberDecemberTotalSeptember Net A/P:$75,960$75,960October purchases:$–October purchases:$–November purchases:$–November purchases:$–December purchases:$–Total cash payments:$75,960$-$-$75,960FebruaryACCOUNTING: What the Numbers Mean, 10eChapter 14 Problem 14.24 Name: Enter NameWhat does it mean? Question 1:Assume that Freese, Inc. decided that because of strong economic conditions in general, a 10% increase in the expected number of units to be sold each month was realistic. Explain the effect, in general, on each of the budgets presented of a 10% increase in the number of units sold.What does it mean? Question 2:Assuming that the number of units sold would not change, explain the effect on the budgets presented of a 5% increase in the selling price of the product. How does this price change effect differ from the sales volume effect you described above?What does it mean? Question 3:The purchasing manager is evaluating an alternative supplier that would provide a slightly lower grade of raw material at a savings from the current price of $4 per pound. The new price would be at $3.50 per pound but the product would now require six pounds of the lower grade of raw material to produce the same number of good finished units as currently achieved. Would you recommend the change to the new supplier? What if the new price was to be $3.00? How about a price of $3.285307? Explain your answers.
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.