ST 7 The Prince Albert Corporation has forecast the following sales for the first seven months of the year FIN Sales Monthly materal purchases are set eque to 40 percent of forecasted sales for the next month. Of the total material cos, 50 percent are pad in the month of purchase and 50 percent are paid in the following month Labour costs will run $4.500 per month, and faed Overhead is $4.500 per month Interest payments on the debt will be $3.500 for both March and Aune Finaly the Prece Albert sales people will receive a 30 percent commesson on sotal sales for the first six months of the year to be part on June 30 Prepare a mormy summary of cash payments for the six months from January through Ane Note Computer December purchases to help get total material payments for January) Turrent th payment Prith July Total payment for trial Labour rests and had Interest payments Sales commission Total cash pents $15,00 anivery Albert Corporation Cat Sch recuery April Help Serb The Prince Albert Corporation has forecast the following sales for the first seven months of the year $15,000 May 17,000 $15,000 23,000 13,000 July 25,000 February April Monthly material purchases are set equal to 40 percent of forecasted sales for the next month. Of the total material costs, 50 percent are paid in the month of purchase and 50 percent are paid in the following month Labour costs will run $4,500 per month and faxed overhead is $4,500 per month interest payments on the debt will be $3.500 for both March and June. Finally, the Prince Albert sales people will receive a 30 percent commission on total sales for the first six months of the year to be paid on June 30 Prepare a monthly summary of cash payments for the six months from January through June (Note: Compute prior December purchases to help get total material payments for January) Sales Purchases Current month payment Prior with payment Total payment for materials Labour costs Fived overhead Interest payments sales commission total cash payments December January Prince Albert Capa Cash Payments Schede February Persh Pet ST 7 The Prince Albert Corporation has forecast the following sales for the first seven months of the year FIN Sales Monthly materal purchases are set eque to 40 percent of forecasted sales for the next month. Of the total material cos, 50 percent are pad in the month of purchase and 50 percent are paid in the following month Labour costs will run $4.500 per month, and faed Overhead is $4.500 per month Interest payments on the debt will be $3.500 for both March and Aune Finaly the Prece Albert sales people will receive a 30 percent commesson on sotal sales for the first six months of the year to be part on June 30 Prepare a mormy summary of cash payments for the six months from January through Ane Note Computer December purchases to help get total material payments for January) Turrent th payment Prith July Total payment for trial Labour rests and had Interest payments Sales commission Total cash pents $15,00 anivery Albert Corporation Cat Sch recuery April Help Serb The Prince Albert Corporation has forecast the following sales for the first seven months of the year $15,000 May 17,000 $15,000 23,000 13,000 July 25,000 February April Monthly material purchases are set equal to 40 percent of forecasted sales for the next month. Of the total material costs, 50 percent are paid in the month of purchase and 50 percent are paid in the following month Labour costs will run $4,500 per month and faxed overhead is $4,500 per month interest payments on the debt will be $3.500 for both March and June. Finally, the Prince Albert sales people will receive a 30 percent commission on total sales for the first six months of the year to be paid on June 30 Prepare a monthly summary of cash payments for the six months from January through June (Note: Compute prior December purchases to help get total material payments for January) Sales Purchases Current month payment Prior with payment Total payment for materials Labour costs Fived overhead Interest payments sales commission total cash payments December January Prince Albert Capa Cash Payments Schede February Persh Pet