Xi sells fruit and vegetables from his market stall for cash. His budgeted sales for February, March and April are $45,000, $50,000 and $55,000 respectively. His suppliers allow him one month's credit in which to pay for the fruit and vegetables that he sells. His purchases cost is budgeted to be 80% of the sales value of his produce. Xi rents his market stall at a cost of $1,000 per month, payable on the first day of each month. Electricity costs for his market stall amount to $200 per month and he pays for these quarterly in March, June, September and December. Xi withdraws $2,000 a month from his business for his own personal expenses. What is Xi's net cash inflow for March? 1. Prepare a cash flow statement 2. Calculate the cash inflow 3. Explain your calculations 4. Provide your analysis

Xi sells fruit and vegetables from his market stall for cash. His budgeted sales for February, March and April are $45,000, $50,000 and $55,000 respectively. His suppliers allow him one month's credit in which to pay for the fruit and vegetables that he sells. His purchases cost is budgeted to be 80% of the sales value of his produce. Xi rents his market stall at a cost of $1,000 per month, payable on the first day of each month. Electricity costs for his market stall amount to $200 per month and he pays for these quarterly in March, June, September and December. Xi withdraws $2,000 a month from his business for his own personal expenses. What is Xi's net cash inflow for March? 1. Prepare a cash flow statement 2. Calculate the cash inflow 3. Explain your calculations 4. Provide your analysis

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter17: Activity Resource Usage Model And Tactical Decision Making

Section: Chapter Questions

Problem 6E: Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of...

See similar textbooks

Similar questions

Paul's Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 40 percent of their fees in the month the service is provided. In the month following service, Paul collects 50 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 70 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul's busiest months: June 1 cash balance $16,700. June 1 supplies on hand $4,500. June 1 accounts receivable $9,400. • June 1 accounts payable $4,400. • Estimated sales for June, July, and August are $28,200, $42,300, and $45,000,…
Paul's Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 40 percent of their fees in the month the service is provided. In the month following service, Paul collects 50 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 80 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul's busiest months: June 1 cash balance $16,300. June 1 supplies on hand $4,500. ⚫ June 1 accounts receivable $17,650. ⚫ June 1 accounts payable $2,800. " • • Estimated sales for June, July, and August are $27,900, $41,900, and $44,900,…
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 50 percent of their fees in the month the service is provided. In the month following service, Paul collects 40 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 70 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul’s busiest months: June 1 cash balance $14,500. June 1 supplies on hand $3,900. June 1 accounts receivable $8,100. June 1 accounts payable $3,800. Estimated sales for June, July, and August are $24,300, $36,500, and $38,900,…
Paul's Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 50 percent of their fees in the month the service is provided. In the month following service, Paul collects 40 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 85 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul's busiest months: ⚫ June 1 cash balance $16,000. ⚫ June 1 supplies on hand $4,400. ⚫ June 1 accounts receivable $9,100. • June 1 accounts payable $4,300. • Estimated sales for June, July, and August are $27,300, $41,000, and $43,900,…
Paul’s Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 50 percent of their fees in the month the service is provided. In the month following service, Paul collects 40 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 85 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul’s busiest months: June 1 cash balance $16,000. June 1 supplies on hand $4,400. June 1 accounts receivable $9,100. June 1 accounts payable $4,300. Estimated sales for June, July, and August are $27,300, $41,000, and $43,900, respectively.…
Boris runs a small manufacturing operation, producing and selling machine parts to European companies. At the start of April, his bank account had an overdrawn bank balance of $2,500. His bank has asked him to produce a budgeted bank balance for the end of April. Boris estimates that his customers will pay him $41,000 of what is owed while he will pay his suppliers $26,000 during the month. What is Boris's budgeted bank account balance at the end of April? $17,500 overdrawn $12,500 overdrawn $12,500 positive balance $17,500 positive balance
Hans Wunderburg runs a small manufacturing operation, producing and selling machine parts to European companies. At the start of April, his bank account had an overdrawn bank balance of $2,500. His bank has asked him to produce a budgeted bank balance for the end of April. Hans estimates that his customers will pay him $41,000 of what is owed while he will pay his suppliers $26,000 during the month. What is Han's budgeted bank account balance at the end of April? $17,500 overdrawn $12,500 overdrawn $12,500 positive balance $17,500 positive balance
Hans Wunderburg runs a small manufacturing operation, producing and selling machine parts to European companies. At the start of April, his bank account had an overdrawn bank balance of $2,500. His bank has asked him to produce a budgeted bank balance for the end of April. Hans estimates that his customers will pay him $41,000 of what is owed while he will pay his suppliers $26,000 during the month. What is Han's budgeted bank account balance at the end of April?
Magnuson is considering buying an eight-harness loom so that she can weave with more intricate patterns in linen. The new loom costs $1,000 and would be depreciated $20 per month. Her bank has agreed to lend her $1,000 at 18% interest per year, $200 payment of principal, plus accrued interest payable each December 31. Magnuson believes she can weave 15 linen place mat sets in time for the Christmas rush if she does not weave any cotton mats. She predicts that each linen set will sell for $50. Linen costs $18 per set. Magnuson's supplier will sell her linen on credit, payable December 31. Magnuson plans to keep her old loom whether or not she buys the new loom. The balance sheet for her weaving business at August 31, 2016, is as follows: Assets Current Assets: Cash Inventory of cotton Total Current Assets Property, Plant, and Equipment: Loom Less: Accumulated Depreciation Total PP&E Total Assets ANNE MAGNUSON, WEAVER Balance Sheet August 31, 2016 $25 175 200 500 (240) 260 $ 460 Current…
Each autumn, as a hobby, Anne Magnuson weaves cotton place mats to sell through 3 local craft shop. The mats sell for $20 per set of four. The shop charges a 10% commission and remits the net proceeds to Magnuson at the end of December. Magnuson has woven and sold 25 sets each year for the past two years. She has enough cotton in inventory to make another 25 sets. She paid $7 per set for the cotton. Magnuson uses a four-harness loom that she purchased for cash exactly two years ago. It is depreciated at the rate of $10 per month. The Accounts Payable balance relates to the cotton inventory and is payable by September 30. Magnuson is considering buying an eight-harness loom so that she can weave more intricate patterns in linen. The new loom costs $1,000 and would be depreciated at $20 per month. Her bank has agreed to lend her $1,000 at 18% interest per year, with $200 payment of principal, plus accrued interest payable each December 31. Magnuson believes she can weave 15 linen place…
Ahmed receives 22% commission on the appliances he sells. He sells a kettle for 2000 taka, a food processor for 9,000 taka and an oven for 8000 taka during July. His basic salary is 34,000 taka (15% house rent, 5% medical allowance, 5% transport allowance). Calculate the total amount he will receive in July.
Patricia's Quilt Shoppe sells homemade Amish quilts. Patricia buys the quilts from local Amish artisans for $220 each, and her shop sells them for $370 each. She also pays a sales commission of 4% of sales revenue to her sales staff. Patricia leases her country-style shop for $800 per month and pays $1,600 per month in payroll costs in addition to the sales commissions. Patricia sold 95 quilts in February. Prepare Patricia's traditional income statement and contribution margin income statement for the month. Prepare the traditional income statement for the month. Patricia's Quilt Shoppe Income Statement For the Month Ended February 28 Less: Less: A