Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance Pedro's Pizza makes frozen pizza dough. The company just finished its first year of operation (12 months, Jan-Dec). The following is its traditional income statement and Balance Sheet Sales (15,000 units) CGS $ 300,000 180.000 $ 120,000 Gross Profit $30,000 30,000 6.000 $54.000 Sales Commissions Salaries Depreciation expense Net Income Cash $5,000 5,000 9,000 Inventory - Finished Goods 3,000 60,000 ( 6.000) $76.000 AP $3,000 7,000 AR Credit Line Inventory-Raw Mat Common Stock 12,000 Retained Earn 54,000 Equipment Acc Depreciation Total Assets Total L & Eq SZ6.000 VCP wants to prepare a cash budget for the first 3 months of the next year. Use the following estimates: The quantity sold is projected to increase 4% for the ycar. Price will increase 5%. Sales are spread evenly throughout the year. CGS should be calculated on a FIFO basis. 25% of sales is collected in the month of sale; the remainder is collected the next month. Inventory: o Last ycar's Finished Goods and Cost of Goods Sold had a constant cost per unit. o. All raw materials is purchased on credit ($1.50 per lb) and is the same price as last year. Each product requires 2.5 lbs). o Ending inventory for both should be 40% of next month's activity (activity is constant). o Beginning and ending WIP is zero 20% of purchases are paid in the month of purchase, 80% in the following. All other expenses are paid with cash. Direct Labor is 0.2 hours per product at $30 per hour. Variable Overhead is $2.25 per product. Fixed Overhead is zero. The credit line is used for cash shortfalls. Excess cash will pay down this line. Interest is 1% per month of last month's balance. Projections are to buy $6000 of new equipment at the end of January. Equipment is depreciated straight-line to zero salvage over 5 years. All of this is used in administration. Sales commission rate will remain the same. Salaries will increase by 4%. VCP wants to maintain a minimum cash balance of at least $5,000. Excess to repay credit line. AT a. Sales A/R Collections (10 points) Jan Feb Mar New Price Sales (units) Sales ($s) AR Beg Bal Sales (Ss) Collections AR End Balance b. Finished Goods/Production (Patties) (10 points) Jan Feb Mar Beginning Unit Cost Beg Inv (units) Sales (units) Req ending Bal (units) Production (units) Actual Ending Finished goods Balance (units) c. DM/RM (Beef) Inventory/Purchases (10 points) Jan Feb Mar Beginning Raw materials (units) Needed for Production (units) Minimum Required Inventory (units) Purchases (units) Purchases ($) Actual Ending Inventory Balance (units) Ending Balance (S) d. Capital Purchases (10 points) Jan Feb Mar Capital Purchases Equip Balance Depreciation Acc. Depreciation c. Cost of Goods Manufactured (10 points) Jan Feb Mar DM used (units) DM used (Ss) DL VOH FOH Total Cost per unit f. Cost of Goods Sold/Ending Finished Goods (FIFO) (10 points) Mar Jan Feb Beg FG (units) Cost per unit, BEG FG Quantity produced (units) Cost per produced unit Quantity of Units sold Cost of Goods Sold Units in Ending FG Cost of Ending FG g. AP/Cash Payments (10 points) Jan Feb Mar AP Beg Bal Purchases (Ss) AP Payments AP End Balance h. Cash Budget/Interest/Credit line (10 points) Jan Feb Mar Cash Beg Bal Collections AP Payments Other Cash Payments: Cash subtotal i. Credit Line/Borrowing/Repay (10 points) Credit Line Beginning balance Borrowing/(Repayment) of credit line Credit Line Ending balance Cash ending balance
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The following is Folex Company's income statement and balance sheet (in millions): The following additional information is available: i) Operating expenses include $35 million of depreciation. ii)...
-
The 2017 comparative income statement and balance sheet of Flowell Design Ltd. follow: Flowell Design Ltd. had no non-cash financing and investing transactions during 2017. During the year, there...
-
A company reports the following income statement and balance sheet information for the current year: Net income $ 600,000 Interest expense 75,000 Average total assets 4,500,000 Determine the rate...
-
1. Estimate the model Debt = 30 + 1lnc + 32Unemp + . Is unemployment significant at the 5% level? 2. You are told that the unemployment rate might have a quadratic influence on monthly debt payments....
-
SFAS No. 144 dealt with asset retirement obligations. Provide a summary of this statement. Additionally, list the implementation issues addressed by the EITF for asset retirement obligations.
-
The following data represent total assets, book value, and market value of common shareholders equity (dollar amounts in millions) for Abbott Labs, IBM, and Target Stores. Abbott Labs manufactures...
-
Certain production equipment used by Lazer Inc. has become obsolete relative to current technology. The company is considering whether it should keep or replace its existing equipment. To aid in this...
-
The following financial data were taken from the annual financial statements of Smith Corporation: Required a. Based on these data, calculate the following for 2008 and 2009: 1. Working capital 2....
-
Explain the SWOT analysis, Business Level Strategies, and Corporate Level Strategies of Rocky Mountain Psychological Services Alberta. Furthermore state the: Consumer base. Income levels....
-
Sherina Smith (Social Security number 785-23-9873) lives at 536 West Lapham Street, Milwaukee, WI 53204, and is self-employed for 2019. She estimates her required annual estimated tax payment for...
-
Maggie has preferences that are 'well behaved'. A utility function that represents her preferences is u(x, x) = + x3. Her income is m, the price of is P1 and the price of X2 is P2. (a) (10 marks)...
-
Consider the following information for NetixX Inc. (INFLX) Netflix, Inc. (unaudited) Consolidated Balance Sheets, in thousands Liabilities and Stockholders' Equity 2018 2019 Current liabilities:...
-
Community General Hospital is experiencing downward trending over the past two years for both patient experience and caregiver engagement scores. Organizational annual goals have included targets for...
-
Sam & Caloy are partners with capital balances of Php 160,000 and Php 80,000. They share profits in the ratio of 3:1. The partners agree to admit Ted as a member of the firm. Give the required...
-
How might a small manufacturing company use both the prevention and the preparation stages of crisis planning with respect to supply chain disruptions?
-
Deborah enters your office ready to discuss the project. She discusses her feedback on the plan thus far. She states that your team is doing an excellent job researching and you've been keeping her...
-
Question 14 5 pts You are required to recommend a load balancer for an organization. The company requires to load requests to various group of webservers depending on contents of the URL (e.g.,...
-
Use the method of Example 4.29 to compute the indicated power of the matrix. 1 0 1
-
Heston Company purchases inventory with a list price of $7,000 for $6,300 on account. Heston pays a transportation company $200 to deliver the inventory. Upon receipt, Heston notices some defects,...
-
The equity section of Jeans Incorporated is as follows: Required Calculate the amount of dividends allocated to common and preferred stockholders under the following situations: (a) $18,000 of total...
-
Xing, Inc., purchases a delivery truck on January 1 for $25,000. The truck has an estimated useful life of five years and an estimated salvage value of $2,500. Required For both the straight-line and...
-
Decade, Inc., recorded certain capital stock transactions shown in the following journal entries: (1) issued common stock for \(\$ 25\) cash per share, (2) purchased treasury shares at \(\$ 40\) per...
-
Label each of the following characteristics of a corporation as either an (A) advantage or a (D) disadvantage: a. Limited liability b. Taxation c. Regulations d. Transferability of ownership
-
The following information relates to Ontario Components, Inc.: a. Calculate the company's return on common stockholders' equity for 2018 and 2019. b. Calculate the company's dividend yield for 2018...
Study smarter with the SolutionInn App