F Budgeting Project - The project should be completed in Excel. When you have finished the project, you need to upload your spreadsheet in the Blackboard assignment link as well as complete the test portion in Blackboard. Make sure your name is on the input's worksheet in the yellow box. Basic Instructions Introduction The purpose of this assignment is to let you see the complexity of budgeting and to develop your spreadsheet skills. There is a lot to do here, so get started right away. The Case Patriot Flag Company a small manufacturing company. They manufacture only American flags. Their product is sold to retail outlets. Stores like Wal-Mart which operate in a close to JIT environment, make frequent orders and expect fast deliveries. The information below pertains to the company's budgeting process. Budgeted sales in flags (units) are as follows: April May June July 20,000 50,000 30,000 25,000 The company desires to have inventory on hand at the end of each month equal to 20 percent of the following month's budgeted sales in units. On March 31, 4,000 units were on hand. Two yards of material are required per flag produced. The company desires to have materials on hand at the end of each month equal to 10 percent of the following month's production needs. The requirement was met on March 31. 10% August 15,000 Each unit sells for $9.50. All sales are on account. The company's collection pattern is: 70% collected the month of sale; 30% collected in the month following. 1/2 The material used in production costs $1.00 per yard. One half of the month's purchases is paid for in the month of purchases; the other half is paid for in the following month. No discount terms are available. The accounts payable as of March 31 were $12,000. Variable selling and administrative expenses are $1.00 per unit sold. Fixed selling and administrative expense is $70,000 per month including $10,000 in depreciation that not a cash outflow of the current month. Each flag requires 3 minutes of labor time to make (.05 hours) and the hourly help is paid $10/hour. Variable manufacturing overhead is $1 per unit produced Fixed manufacturing overhead is $50,500 per month including $20,500 in depreciation that is not a current cash outflow. All cash disbursements for manufacturing overhead are paid in the month incurred. All cash disbursements for selling and administrative costs are paid in the month incurred. Cash dividends in the amount of $51,000 are to be paid to shareholders in April. These dividends wer declared in March. Equipment purchases and payments of $143,700 are scheduled for May and $48,800 for June. Additionally, Patriot has the following balance sheet as of March 31, 20XX. Assets Liabilities and Equities Cash Accounts payable Accounts Receivable Notes Payable $40,000 30,000 $12,000 $0 MASCORING

anyone can help with preparing the Balance sheet for this project?

Budgeting Project - Basic Instructions The project should be completed in Excel. as well as complete the test portion in Blackboard, Make sure your name is on the input's worksheet in the yellow box. Introduction The purpose of this assignment is to let you see the complexity of budgeting and to develop your spreadsheet skills. There is a lot to do here, so get started right away. The case Patriot Flag Company is a small manufacturing company. They manufacture only American flags. Their product is sold to retail outlets. Stores like Wal-Mart which operate in a close to JIT environment, make frequent orders and expect fast deliveries. The information below pertains to the company's budgeting process, Budgeted sales in flags (units) are as follows: - Each unit sells for $9.50. - All sales are on account. The company's collection pattern is: 70% collected the month of sale; 30% collected in the month following. - The company desires to have inventory on hand at the end of each month equal to 20 percent of the following month's budgeted sales in units. On March 31,4,000 units were on hand. - Two yards of material are required per flag produced. The company desires to have materials on hand at the end of each month equal to 10 percent of the following month's production needs. The requirement was met on March 31. 10 \% - The material used in production costs $1.00 per yard. One half of the month's purchases is paid for in the month of purchases; the other balf is paid for in the following month. No discount terms are available. The accounts payable as of March 31 were $12,000. - Each flag requires 3 minutes of labor time to make (.05 hours) and the hourly help is paid $10/hour. - Variable manufacturing overhead is $1 per unit produced - Fixed manufacturing overhead is $50,500 per month including $20,500 in depreciation that is not a current cash outflow. - All cash disbursements for manufacturing overhead are paid in the month incurred. - Variable selling and administrative expenses are $1.00 per unit sold. - Fixed selling and administrative expense is $70,000 per month including $10,000 in depreciation that not a cash outflow of the current month. - All cash disbursements for selling and administrative costs are paid in the month incurred. - Cash dividends in the amount of $51,000 are to be paid to shareholders in April. These dividends we declared in March. - Fauioment purchases and payments of $143,700 are scheduled for May and $48,800 for June. Budgeting Project - Basic Instructions The project should be completed in Excel. as well as complete the test portion in Blackboard, Make sure your name is on the input's worksheet in the yellow box. Introduction The purpose of this assignment is to let you see the complexity of budgeting and to develop your spreadsheet skills. There is a lot to do here, so get started right away. The case Patriot Flag Company is a small manufacturing company. They manufacture only American flags. Their product is sold to retail outlets. Stores like Wal-Mart which operate in a close to JIT environment, make frequent orders and expect fast deliveries. The information below pertains to the company's budgeting process, Budgeted sales in flags (units) are as follows: - Each unit sells for $9.50. - All sales are on account. The company's collection pattern is: 70% collected the month of sale; 30% collected in the month following. - The company desires to have inventory on hand at the end of each month equal to 20 percent of the following month's budgeted sales in units. On March 31,4,000 units were on hand. - Two yards of material are required per flag produced. The company desires to have materials on hand at the end of each month equal to 10 percent of the following month's production needs. The requirement was met on March 31. 10 \% - The material used in production costs $1.00 per yard. One half of the month's purchases is paid for in the month of purchases; the other balf is paid for in the following month. No discount terms are available. The accounts payable as of March 31 were $12,000. - Each flag requires 3 minutes of labor time to make (.05 hours) and the hourly help is paid $10/hour. - Variable manufacturing overhead is $1 per unit produced - Fixed manufacturing overhead is $50,500 per month including $20,500 in depreciation that is not a current cash outflow. - All cash disbursements for manufacturing overhead are paid in the month incurred. - Variable selling and administrative expenses are $1.00 per unit sold. - Fixed selling and administrative expense is $70,000 per month including $10,000 in depreciation that not a cash outflow of the current month. - All cash disbursements for selling and administrative costs are paid in the month incurred. - Cash dividends in the amount of $51,000 are to be paid to shareholders in April. These dividends we declared in March. - Fauioment purchases and payments of $143,700 are scheduled for May and $48,800 for June. Budgeting Project - Basic Instructions The project should be completed in Excel. as well as complete the test portion in Blackboard, Make sure your name is on the input's worksheet in the yellow box. Introduction The purpose of this assignment is to let you see the complexity of budgeting and to develop your spreadsheet skills. There is a lot to do here, so get started right away. The case Patriot Flag Company is a small manufacturing company. They manufacture only American flags. Their product is sold to retail outlets. Stores like Wal-Mart which operate in a close to JIT environment, make frequent orders and expect fast deliveries. The information below pertains to the company's budgeting process, Budgeted sales in flags (units) are as follows: - Each unit sells for $9.50. - All sales are on account. The company's collection pattern is: 70% collected the month of sale; 30% collected in the month following. - The company desires to have inventory on hand at the end of each month equal to 20 percent of the following month's budgeted sales in units. On March 31,4,000 units were on hand. - Two yards of material are required per flag produced. The company desires to have materials on hand at the end of each month equal to 10 percent of the following month's production needs. The requirement was met on March 31. 10 \% - The material used in production costs $1.00 per yard. One half of the month's purchases is paid for in the month of purchases; the other balf is paid for in the following month. No discount terms are available. The accounts payable as of March 31 were $12,000. - Each flag requires 3 minutes of labor time to make (.05 hours) and the hourly help is paid $10/hour. - Variable manufacturing overhead is $1 per unit produced - Fixed manufacturing overhead is $50,500 per month including $20,500 in depreciation that is not a current cash outflow. - All cash disbursements for manufacturing overhead are paid in the month incurred. - Variable selling and administrative expenses are $1.00 per unit sold. - Fixed selling and administrative expense is $70,000 per month including $10,000 in depreciation that not a cash outflow of the current month. - All cash disbursements for selling and administrative costs are paid in the month incurred. - Cash dividends in the amount of $51,000 are to be paid to shareholders in April. These dividends we declared in March. - Fauioment purchases and payments of $143,700 are scheduled for May and $48,800 for June. Budgeting Project - Basic Instructions The project should be completed in Excel. as well as complete the test portion in Blackboard, Make sure your name is on the input's worksheet in the yellow box. Introduction The purpose of this assignment is to let you see the complexity of budgeting and to develop your spreadsheet skills. There is a lot to do here, so get started right away. The case Patriot Flag Company is a small manufacturing company. They manufacture only American flags. Their product is sold to retail outlets. Stores like Wal-Mart which operate in a close to JIT environment, make frequent orders and expect fast deliveries. The information below pertains to the company's budgeting process, Budgeted sales in flags (units) are as follows: - Each unit sells for $9.50. - All sales are on account. The company's collection pattern is: 70% collected the month of sale; 30% collected in the month following. - The company desires to have inventory on hand at the end of each month equal to 20 percent of the following month's budgeted sales in units. On March 31,4,000 units were on hand. - Two yards of material are required per flag produced. The company desires to have materials on hand at the end of each month equal to 10 percent of the following month's production needs. The requirement was met on March 31. 10 \% - The material used in production costs $1.00 per yard. One half of the month's purchases is paid for in the month of purchases; the other balf is paid for in the following month. No discount terms are available. The accounts payable as of March 31 were $12,000. - Each flag requires 3 minutes of labor time to make (.05 hours) and the hourly help is paid $10/hour. - Variable manufacturing overhead is $1 per unit produced - Fixed manufacturing overhead is $50,500 per month including $20,500 in depreciation that is not a current cash outflow. - All cash disbursements for manufacturing overhead are paid in the month incurred. - Variable selling and administrative expenses are $1.00 per unit sold. - Fixed selling and administrative expense is $70,000 per month including $10,000 in depreciation that not a cash outflow of the current month. - All cash disbursements for selling and administrative costs are paid in the month incurred. - Cash dividends in the amount of $51,000 are to be paid to shareholders in April. These dividends we declared in March. - Fauioment purchases and payments of $143,700 are scheduled for May and $48,800 for June