Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Complete the following pay schedule and then configure and prettify it for printing. Total Sales is the sum of all sales Jan through Jun. Base

image text in transcribed

Complete the following pay schedule and then configure and prettify it for printing. Total Sales is the sum of all sales Jan through Jun. Base Pay is 14% of Total Sales. Bonus is 5% of the amount of Total Sales in excess of $25,000. Give the column headings and the data within the table appropriate formats. Put both a date and a time stamp on this report using Now() with appropriate formatting. Put an appropriate heading on the report using both cell merging and centering. There is no need to actually print this report. It will be graded by examining Print Preview. Print in "Portrait". Make it all fit on one page, adjusting margins and changing font if necessary. Do not include these instructions as a part of what is printed. Total Pay Name Jan Feb Mar Apr May Jun Total Sales: Base Pay: Bonus: AguinagaJose 15000 5723 3535 4942 5330 3516 38046.00 0.14 Bobby Ricky 2524 3434 3557 5166 4237 4252 23170.00 BokharySummer 4611 2498 2532 5901 6216 3779 25537.00 BriceBruce 5524 3320 6263 3708 2805 3774 25394.00 Clinton Bill 2179 6897 2669 4974 6793 5710 29222.00 ClumpfHuman 6335 3721 5330 4739 4621 3702 28448.00 DeCastroAnn 4342 5958 0 4831 6470 4883 26484.00 DeLosSantosVicky 4628 4947 2192 2231 4050 2348 20396.00 FrolicLilly 4486 4118 4233 5297 3239 2825 24198.00 ImmlerMark 5801 4755 5540 6153 5118 3295 30662.00 KesslerCaitlin 5371 5118 1000 2600 3189 4530 21808.00 King Major 2616 6672 6842 3939 3657 5416 29142.00 LeloJimBob 3166 5282 4180 3551 5852 0 22031.00 LenoJay 2015 0 5906 6845 0 3936 18702.00 LenzAlisha 3952 4037 4832 6399 3588 5957 28765.00 LightClara 6442 2827 5363 2407 3105 4898 25042.00 Lockwood Jillian 6381 2560 6818 6274 6508 4113 32654.00 LopezAnthony 2791 2382 2961 6454 5701 2520 22809.00 Lopez Jose 6180 5567 6880 6610 500 6230 31967.00 Lowe Patrick 2177 6395 6794 6271 3112 4263 29012.00 Ivnch lohn 6599 3860 2217 2722 4863 4020 24281 00 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions