need help preparing my job cost sheets ive procided background info

ompleted. The proce a Date Completed Units Completed Factory Overhead Date Rate 14 Job Cost Sheet Start Date 12/15/2020 3racing bicycles Direct Labor Date Cost Job No Desc Cost Date Cost BIO Total Total Direct Materials Reg. No. 20 21 22 2000 Total 143 Cost Summary Beginning Balance 150 Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet 15 Start Date Job No. Desc Date Completed Units Completed Factory Overhead Date Rate Direct Labor Cost Direct Materials Reg. No Date Cost Date Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet Start Date Job No. Desc Date Completed Units Completed Factory Overhead Date Rate Direct Labor Direct Materials Reg. No. Date Cost Date Cost Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet Start Date your Practices ne Chart of eral Led int nr us Direct Materials Reg. No Date Cost Date Completed Units Completed Factory Overhead Date Rate Direct Labor Hrs Date Cost Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet Job No. Desc Start Date Date Completed Units Completed Factory Overhead Date Rate Direct Materials Reg. No. Direct Labor Hrs Date Cout Cost Date Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost January 2021 Transactions: 01 Per the lease agreement, which requires the first three months' rent be paid in Toll advance, Bearkat Bicycles paid $6,600 to Sunset Run Properties to lease 1,000 square feet of retail space. 01 A 10-year note was issued to purchase an existing 3,900 square foot building on an acre of land for $105,000. The value of the land was only $50,000. The building has an estimated useful life of 20 years and a salvage value of $9,400. 02 Raw materials for production totaling $37,500 were purchased on account. Direct materials amounted to $34,400 and indirect materials amounted to $3,100. 04 The production department requisitioned materials for the jobs in the following amounts: Requisition No. Job Direct Indirect 20 14 $ 610 $ 15 21 15 $1,425 $ 15 22 16 -$2,400 $ 25 05 Bearkat Bicycles received $16,100 owed from a customer, The Huntsville Hotshots, and deposited this amount into the company's checking account. 05 Paid the accrued payroll from the last two weeks of December 2020. 10 Requisitioned more materials for jobs in progress in the following amounts: Requisition No. Job Direct Indirect 15 $1,860 $ 19 be 24 16 $2,720 $ 21 25 17 $5,905 $ 25 TE 26 18 $1,420 $ 23 23 15 Invoice for $400 from Huntsville Water & Electric is received and due February 10th. The invoice includes the water and electricity used by Bearkat Bicycles. Assume 58% of the invoice reflects factory use and the other 42% reflects administrative activities. DAN The company declares and pays a cash dividend of $.39 per share. 20 22 30 The first note payment of $4,238 is made to the First Bank of Huntsville, which Includes $3,938 in interest. Employees are paid monthly on the 5th of every month. Accrue the payroll for the entire month of January, which will be paid on February 5th. The payroll includes the sales and administrative staff that worked a total of 60 hours and earns $12.50 per hour, the part-time factory maintenance worker that worked a total of 50 hours and earns $10.00 per hour, the production supervisor earns $700 a week (assume an even four weeks was worked). Ignore all related payroll taxes. In addition, the following hours were incurred by assembly line workers based on the production time cards for each job: Job Hours $10 $10 $10 Rate 14 15 16 17 10 77 90 100 $10 $10 18 27 30 Apply factory overhead to all jobs (14, 15, 16, 17, & 18). Overhead is allocated based on direct labor costs. Budgeted overhead costs for the year were estimated to be $46,000. Bearkat estimates that direct labor costs will amount to $115,000 for the year. 30 Jobs 14, 15, and 16 were completed and transferred to the warehouse. 30 Sold all bikes from Job 14 and Job 15, and 6 bicycles from Job 16 on account. Ignore sales tax. 31 Job 17 was completed and transferred to the warehouse. Check figures: Cash $37,565 no mono son Indirect Materials 3,407 Subota Work in Process 1,798 wat ons Wages Payable 7,090 Factory Overhead 2,459 Unit cost for Job 16 708.89 Background Information: solda 92919yoia 16311698 In 2020, Sammy Bearkat opened a bicycle manufacturing business named Bearkat Bicycles. Sammy Bearkat, the sole stockholder, invested $50,000 for 10,000 shares of common stock in December. The company currently manufactures and sells racing bicycles for $2,350 to customers in Huntsville, Texas and its surrounding areas. His business has become so successful that Sammy can no longer build the bicycles out of his garage; thus, he has decided to expand his business. To meet demand, he has hired eight employees including a production supervisor, a salesperson, and an administrative assistant. The company has just signed a one-year lease with a local broker for downtown retail space. The company has one order (Job 14) that was started on December 15, 2020 for 3 racing bicycles that are still in process but will be completed in the next month. Bearkat Bicycles uses a manual accounting system and a chart of accounts has been provided. They've received four new orders for racing bicycles, which Bearkat will assign into four jobs as follows: gaininigo8 199/12 1200 dolari ni a dolot sandlad grinniged 9 na DE guntia srl no Boal OSOS [ 190m990 to 25 9onsisd SIW 97 al 93nlod o Job 15: 6 racing bicycles ordered by Morris Masterpieces, Inc. 2 o Job 16:9 racing bicycles ordered by the Amazing Aspen Cyclists. o Job 17: 10 racing bicycles ordered by Robinson Roadsters, Inc. srt 10 o Job 18:8 racing bicycles ordered by Barker's Bike Emporium. batail anoidsansvar olsuolistonog sitt ni a loro or brosa S hom toob 129169n er dans le tuolls buon ons dagegno 199bal yang ant nl no site91 dolina lis 2016 Ismisbow 320 2toare 1200 dol svi9020 od no 21209 dolls boss.d 219 9612 27205 doi no 293 Bearkat Bicycles Balance Sheet December 31, 2020 Assets 37,453 18,100 2,000 450 1,100 Current assets: Cash Accounts receivable Direct Materials Inventory Indirect Materials Inventory Work in Process Finished Goods Office Supplies Total current assets Property, plant and equipment: Factory Tools Accumulated Depreciation Total property, plant, and equipment Total assets 65 $ 59,168 $ 10,125 (78) 10,047 $ 69,215 8,750 1,250 $ 10,000 $ 10,000 Liabilities Current liabilities: Accounts payable Wages payable Total current liabilities Total liabilities Stockholders' Equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 50,000 9215 59,215 $ 69,215 Chart of Accounts Assets 1000 Cash 1100 Accounts Receivable 1250 Direct Materials inventory 1260 Indirect Materials Inventory 1270 Work in Process Inventory 1280 Finished Goods Inventory 1300 Office Supplies 1400 Prepaid Rent 1500 Factory Tools 1510 Accumulated Depreciation Factory Tools 1700 Building 1710 Accumulated Depreciation Building sat e 1900 Land COOL Liabilities 2000 Accounts Payable 2100 Utilities Payable 2300 Wages Payable 2400 Dividends Payable 2700 Notes Payable 21 Stockholders' Equity 3000 Common Stock 3500 Retained Earnings not 3600 Cash Dividends Revenues 4000 Sales Revenue Expenses 5000 Cost of Goods Sold 5500 Factory Overhead 6200 Office Supplies Expense 6300 Rent Expense 6500 Utilities Expense 6600 Wages Expense 6700 Depreciation Expense 6800 Interest Expense ompleted. The proce a Date Completed Units Completed Factory Overhead Date Rate 14 Job Cost Sheet Start Date 12/15/2020 3racing bicycles Direct Labor Date Cost Job No Desc Cost Date Cost BIO Total Total Direct Materials Reg. No. 20 21 22 2000 Total 143 Cost Summary Beginning Balance 150 Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet 15 Start Date Job No. Desc Date Completed Units Completed Factory Overhead Date Rate Direct Labor Cost Direct Materials Reg. No Date Cost Date Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet Start Date Job No. Desc Date Completed Units Completed Factory Overhead Date Rate Direct Labor Direct Materials Reg. No. Date Cost Date Cost Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet Start Date your Practices ne Chart of eral Led int nr us Direct Materials Reg. No Date Cost Date Completed Units Completed Factory Overhead Date Rate Direct Labor Hrs Date Cost Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost Job Cost Sheet Job No. Desc Start Date Date Completed Units Completed Factory Overhead Date Rate Direct Materials Reg. No. Direct Labor Hrs Date Cout Cost Date Cost Total Total Total Cost Summary Beginning Balance Total Direct Materials Total Direct Labor Total Factory Overhead Total Cost Unit Cost January 2021 Transactions: 01 Per the lease agreement, which requires the first three months' rent be paid in Toll advance, Bearkat Bicycles paid $6,600 to Sunset Run Properties to lease 1,000 square feet of retail space. 01 A 10-year note was issued to purchase an existing 3,900 square foot building on an acre of land for $105,000. The value of the land was only $50,000. The building has an estimated useful life of 20 years and a salvage value of $9,400. 02 Raw materials for production totaling $37,500 were purchased on account. Direct materials amounted to $34,400 and indirect materials amounted to $3,100. 04 The production department requisitioned materials for the jobs in the following amounts: Requisition No. Job Direct Indirect 20 14 $ 610 $ 15 21 15 $1,425 $ 15 22 16 -$2,400 $ 25 05 Bearkat Bicycles received $16,100 owed from a customer, The Huntsville Hotshots, and deposited this amount into the company's checking account. 05 Paid the accrued payroll from the last two weeks of December 2020. 10 Requisitioned more materials for jobs in progress in the following amounts: Requisition No. Job Direct Indirect 15 $1,860 $ 19 be 24 16 $2,720 $ 21 25 17 $5,905 $ 25 TE 26 18 $1,420 $ 23 23 15 Invoice for $400 from Huntsville Water & Electric is received and due February 10th. The invoice includes the water and electricity used by Bearkat Bicycles. Assume 58% of the invoice reflects factory use and the other 42% reflects administrative activities. DAN The company declares and pays a cash dividend of $.39 per share. 20 22 30 The first note payment of $4,238 is made to the First Bank of Huntsville, which Includes $3,938 in interest. Employees are paid monthly on the 5th of every month. Accrue the payroll for the entire month of January, which will be paid on February 5th. The payroll includes the sales and administrative staff that worked a total of 60 hours and earns $12.50 per hour, the part-time factory maintenance worker that worked a total of 50 hours and earns $10.00 per hour, the production supervisor earns $700 a week (assume an even four weeks was worked). Ignore all related payroll taxes. In addition, the following hours were incurred by assembly line workers based on the production time cards for each job: Job Hours $10 $10 $10 Rate 14 15 16 17 10 77 90 100 $10 $10 18 27 30 Apply factory overhead to all jobs (14, 15, 16, 17, & 18). Overhead is allocated based on direct labor costs. Budgeted overhead costs for the year were estimated to be $46,000. Bearkat estimates that direct labor costs will amount to $115,000 for the year. 30 Jobs 14, 15, and 16 were completed and transferred to the warehouse. 30 Sold all bikes from Job 14 and Job 15, and 6 bicycles from Job 16 on account. Ignore sales tax. 31 Job 17 was completed and transferred to the warehouse. Check figures: Cash $37,565 no mono son Indirect Materials 3,407 Subota Work in Process 1,798 wat ons Wages Payable 7,090 Factory Overhead 2,459 Unit cost for Job 16 708.89 Background Information: solda 92919yoia 16311698 In 2020, Sammy Bearkat opened a bicycle manufacturing business named Bearkat Bicycles. Sammy Bearkat, the sole stockholder, invested $50,000 for 10,000 shares of common stock in December. The company currently manufactures and sells racing bicycles for $2,350 to customers in Huntsville, Texas and its surrounding areas. His business has become so successful that Sammy can no longer build the bicycles out of his garage; thus, he has decided to expand his business. To meet demand, he has hired eight employees including a production supervisor, a salesperson, and an administrative assistant. The company has just signed a one-year lease with a local broker for downtown retail space. The company has one order (Job 14) that was started on December 15, 2020 for 3 racing bicycles that are still in process but will be completed in the next month. Bearkat Bicycles uses a manual accounting system and a chart of accounts has been provided. They've received four new orders for racing bicycles, which Bearkat will assign into four jobs as follows: gaininigo8 199/12 1200 dolari ni a dolot sandlad grinniged 9 na DE guntia srl no Boal OSOS [ 190m990 to 25 9onsisd SIW 97 al 93nlod o Job 15: 6 racing bicycles ordered by Morris Masterpieces, Inc. 2 o Job 16:9 racing bicycles ordered by the Amazing Aspen Cyclists. o Job 17: 10 racing bicycles ordered by Robinson Roadsters, Inc. srt 10 o Job 18:8 racing bicycles ordered by Barker's Bike Emporium. batail anoidsansvar olsuolistonog sitt ni a loro or brosa S hom toob 129169n er dans le tuolls buon ons dagegno 199bal yang ant nl no site91 dolina lis 2016 Ismisbow 320 2toare 1200 dol svi9020 od no 21209 dolls boss.d 219 9612 27205 doi no 293 Bearkat Bicycles Balance Sheet December 31, 2020 Assets 37,453 18,100 2,000 450 1,100 Current assets: Cash Accounts receivable Direct Materials Inventory Indirect Materials Inventory Work in Process Finished Goods Office Supplies Total current assets Property, plant and equipment: Factory Tools Accumulated Depreciation Total property, plant, and equipment Total assets 65 $ 59,168 $ 10,125 (78) 10,047 $ 69,215 8,750 1,250 $ 10,000 $ 10,000 Liabilities Current liabilities: Accounts payable Wages payable Total current liabilities Total liabilities Stockholders' Equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $ 50,000 9215 59,215 $ 69,215 Chart of Accounts Assets 1000 Cash 1100 Accounts Receivable 1250 Direct Materials inventory 1260 Indirect Materials Inventory 1270 Work in Process Inventory 1280 Finished Goods Inventory 1300 Office Supplies 1400 Prepaid Rent 1500 Factory Tools 1510 Accumulated Depreciation Factory Tools 1700 Building 1710 Accumulated Depreciation Building sat e 1900 Land COOL Liabilities 2000 Accounts Payable 2100 Utilities Payable 2300 Wages Payable 2400 Dividends Payable 2700 Notes Payable 21 Stockholders' Equity 3000 Common Stock 3500 Retained Earnings not 3600 Cash Dividends Revenues 4000 Sales Revenue Expenses 5000 Cost of Goods Sold 5500 Factory Overhead 6200 Office Supplies Expense 6300 Rent Expense 6500 Utilities Expense 6600 Wages Expense 6700 Depreciation Expense 6800 Interest Expense