Answered: Calculate the production budget (in…

Business

Accounting

Calculate the production budget (in unit) for the 1st quarter 2022 (1st January to 31st March 2022).

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter6: Managing Cash Flow

Section: Chapter Questions

Problem 13SEP

See similar textbooks

Similar questions

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Uptons balance sheet as of December 31, 2019, is shown here (millions of dollars): Sales for 2019 were 350 million, and net income for the year was 10.5 million, so the firms profit margin was 3.0%. Upton paid dividends of 4.2 million to common stockholders, so its payout ratio was 40%. Its tax rate was 25%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2020. a. If sales are projected to increase by 70 million, or 20%, during 2020, use the AFN equation to determine Uptons projected external capital requirements. b. Using the AFN equation, determine Uptons self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? c. Use the forecasted financial statement method to forecast Uptons balance sheet for December 31, 2020. Assume that all additional external capital is raised as a line of credit at the end of the year. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt.) Assume Uptons profit margin and dividend payout ratio will be the same in 2020 as they were in 2019. What is the amount of the line of credit reported on the 2020 forecasted balance sheets? (Hint: You dont need to forecast the income statements because the line of credit is taken out on the last day of the year and you are given the projected sales, profit margin, and dividend payout ratio; these figures allow you to calculate the 2020 addition to retained earnings for the balance sheet without actually constructing a full income statement.)
1. Gxsport is a small business manufactures sportswear focusing on tracksuits. Gxsportperform very well in 2021 with yearly sales amounting to RM630,000, equivalent to 12,600pieces sold. For the 1st quarter of 2022, the sales are predicted to increase by 7% ascompared to 2021’s sales due to the raised of awareness for a healthy lifestyle.The price of the tracksuit is RM50 per piece. The labour rate is RM7 per hour and eachpiece of tracksuit requires 0.4 hours to make. Manufacturing overheads are charges atRM1.50 per piece. The inventory is expected to have a balance of 500 pieces of tracksuitsas at 1st January 2022 and increase by 10% as at 31st March 2022. 1. Calculate the production budget (in unit) for the 1st quarter 2022 (1st January to 31st March2022).
he Schrödinger Science Store operates a retail store in a local shopping mall. The results of operations for the fourth quarter of 2020 are as follows: Sales $350,000 Less cost of sales 205,000 Gross margin 145,000 Less selling, general, and administrative expenses 50,000 Income before taxes 95,000 Less taxes on income 19,000 Net income $ 76,000 Additional information: Sales are expected to increase by 10 percent and cost of sales are expected to increase by 12 percent in each of the next two quarters. 75 percent of sales are collected in the quarter of sale, and 25 percent are collected in the quarter following sale. The balance in accounts receivable at the end of 2020 relates to sales in the fourth quarter of 2020. Inventory purchases in the fourth quarter of 2020 are $200,000. The balance in accounts payable at the end of 2020 relates to purchases in the fourth quarter of 2020. Inventory at the end of 2020 is $150,000. For 2021, the company plans to hold…
ZNet Co. is a web-based retail company. The company reports the following for the past year. The company’s CEO believes that sales for next year will increase by 20% and both profit margin (%) and the level of average invested assets will be the same as for the past year. 1. Compute return on investment for the past year. 2. Compute profit margin for the past year. 3. If the CEO’s forecast is correct, what will return on investment equal for next year? 4. If the CEO’s forecast is correct, what will investment turnover equal for next year? Sales . $5,000,000 Operating income . $1,000,000 Average invested assets . $12,500,000
Starborn Company has just been established as a new company to manufacture furniture. The company expects to earn $1 million after-taxes during its first year. The company president has asked for a projected balance sheet based on ratios similar to the industry average. Assuming all sales are made on credit, calculations utilize a 365-day year, and final numbers are rounded to the nearest thousand, prepare a projected balance sheet for Starborn based on the following industry ratios: Current Ratio: 2:1 Quick Ratio: 1:1 Net Profit Margin: 10% Average Collection Period: 20 days Debt Ratio: 40% Total Asset Turnover Ratio: 2 times Current Liabilities/Stockholder's Equity: 20% Create your balance sheet based on the following format: Cash Total Current Liabilities Accounts Receivable Long-term Debt Inventory Total Debt Total Current Assets Stockholder's Equity Net Fixed Assets Total Liabilities and…
Rose Turkish company is a new company and will start to operations in January, 2022. Its beginning cash balance is 5.000 TL It plans to sell 1000 boxes at 20 each month. 90of the sales will be in cash 10% of sales will be collected in the following month. In January, short term investment will be sold at 10,000 in cash Production costs will be 20, 000 and selling and administrative expenses will be 10, 000TL in January and all will be paid in cash Production costs will be 20.000 TL and selling and administrative expenses will be 5,000 February and all will be paid in cash Minimum cash balance is 5,000 Prepare a cash budget for January and February 2022
Petlassa is a company with a large distribution network and selling automobile tires. The company's finance manager will meet with the General Manager to discuss the financial information for the next 3 months. Last month's TL sales amount and sales forecasts for the next 3 months are given below:Last Month Estimations/ForecastsMay 250,000 June 100,000July 150,000August 250,000September 100,000The company collects 40% of its sales in cash and 60% as 1 month term (later). Purchases make up 60% of sales. Petlassa makes the relevant purchase one month before its sales; However, it makes the payment 1 month after the purchase date. Labor expenses are 5% of sales and paid in the relevant month. General administration expenses amount to 15% of the sales and are paid in the relevant month. 10,000 TL income tax will be paid in August. The 50,000 TL dividend payment will be made in June. The cash balance on June 1 is required to be 80,000 TL.All transactions take place at the end of the…
CarniTrin is a manufacturer of Carnival costumes in a highly competitive market. Thecompany's management team is seeking guidance on the use of financial performancemeasures to identify the key drivers of the company's financial performance and develop astrategy to improve it.The following data relate to the company for the year 2022: In its clothing division, the company has $6,000,000 invested in assets. After-taxoperating income from sales of clothing in 2022 is $900,000. Income for the clothingdivision has grown steadily over the last few years. The cosmetics division has $14,000,000 invested in assets and an after-tax operatingincome in 2022 of $1,900,000. The weighted-average cost of capital for CarniTrin is 10% and the 2021’s after-taxreturn on investment for each division was 15%. The general manager of CarniTrin has asserted that in the future, managers shouldhave their compensation structure aligned with their performance measures with nofixed salaries. However, the…
CarniTrin is a manufacturer of Carnival costumes in a highly competitive market. Thecompany's management team is seeking guidance on the use of financial performancemeasures to identify the key drivers of the company's financial performance and develop astrategy to improve it. The following data relate to the company for the year 2022: In its clothing division, the company has $6,000,000 invested in assets. After-taxoperating income from sales of clothing in 2022 is $900,000. Income for the clothingdivision has grown steadily over the last few years.  The cosmetics division has $14,000,000 invested in assets and an after-tax operatingincome in 2022 of $1,900,000.  The weighted-average cost of capital for CarniTrin is 10% and the 2021’s after-taxreturn on investment for each division was 15%.  The general manager of CarniTrin has asserted that in the future, managers shouldhave their compensation structure aligned with their performance measures with nofixed salaries.…
CarniTrin is a manufacturer of Carnival costumes in a highly competitive market. Thecompany's management team is seeking guidance on the use of financial performancemeasures to identify the key drivers of the company's financial performance and develop astrategy to improve it. The following data relate to the company for the year 2022: In its clothing division, the company has $6,000,000 invested in assets. After-taxoperating income from sales of clothing in 2022 is $900,000. Income for the clothingdivision has grown steadily over the last few years.  The cosmetics division has $14,000,000 invested in assets and an after-tax operatingincome in 2022 of $1,900,000.  The weighted-average cost of capital for CarniTrin is 10% and the 2021’s after-taxreturn on investment for each division was 15%. The general manager of CarniTrin has asserted that in the future, managers shouldhave their compensation structure aligned with their performance measures with nofixed salaries. However, the…
Ricardo Entertainment recently reported the following income statement:Sales 12,000,000Cost of goods sold 7,500,000EBIT 4,500,000Interest 1,500,000EBT 3,000,000Taxes (40%) 1,200,000Net income 1,800,000The company’s CFO, Fred Mertz, wants to see a 25 percent increase in net income over the next year.In other words, his target for next year’s net income is $2,250,000. Mertz has made the followingobservations: Ricardo’s operating margin (EBIT/Sales) was 37.5 percent this past year. Mertz expects thatnext year this margin will increase to 40 percent. Ricardo’s interest expense is expected to remain constant. Ricardo’s tax rate is expected to remain at 40 percent.On the basis of these numbers, what is the percentage increase in sales that Ricardo needs in order tomeet Mertz’s target for net income?
Please answer in detail CarniTrin is a manufacturer of Carnival costumes in a highly competitive market. The company's management team is seeking guidance on the use of financial performance measures to identify the key drivers of the company's financial performance and develop a strategy to improve it. The following data relate to the company for the year 2022: In its clothing division, the company has $6,000,000 invested in assets. After-tax operating income from sales of clothing in 2022 is $900,000. Income for the clothing division has grown steadily over the last few years. The cosmetics division has $14,000,000 invested in assets and an after-tax operating income in 2022 of $1,900,000. The weighted-average cost of capital for CarniTrin is 10% and the 2021’s after-tax return on investment for each division was 15%. The general manager of CarniTrin has asserted that in the future, managers should have their compensation structure aligned with their performance measures…